epost
Active Member
Anyone have experience restructuring the tablespaces in Oracle under JDE.
I'm going to move our development box to uniform extent tablespaces using
SAFE methodology. If your install is like ours you have tablespaces such as
proddtat, proddtai, prodctlt, prodctli...If you installed using default
storage parameters from JDE I assume you have some tables with too many
extents and also potential fragmentation...to find out just run "select *
from dba_segments where extents > 1024".
Anyway, is anyone aware of any potential problems with doing this? I'm
thinking of creating proddtat_big, proddtat_medium and proddtat_small (as
well as others) and placing objects accordingly should be fine but I'm
worried about any problems if we upgrade. Let me know if you have any
thoughts or ideas on this matter.
Thanks,
Ethan
www.freeocp.com
------------------------------------------------------------------------------
This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you.
==============================================================================
I'm going to move our development box to uniform extent tablespaces using
SAFE methodology. If your install is like ours you have tablespaces such as
proddtat, proddtai, prodctlt, prodctli...If you installed using default
storage parameters from JDE I assume you have some tables with too many
extents and also potential fragmentation...to find out just run "select *
from dba_segments where extents > 1024".
Anyway, is anyone aware of any potential problems with doing this? I'm
thinking of creating proddtat_big, proddtat_medium and proddtat_small (as
well as others) and placing objects accordingly should be fine but I'm
worried about any problems if we upgrade. Let me know if you have any
thoughts or ideas on this matter.
Thanks,
Ethan
www.freeocp.com
------------------------------------------------------------------------------
This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you.
==============================================================================