Link to home
Create AccountLog in
Avatar of d27m11y d27m11y
d27m11y d27m11yFlag for United States of America

asked on

move DB objects from one table space to the other in multiple schemes improve performance

Hi,

Need your help.

Planning to move DB Objects from one table space to the other.  This table space is being used across different schemas in the same Oracledatabase.
How do I move DB objects.

This is a high priority issue.

Please help me
SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of d27m11y d27m11y

ASKER

How about CLOb and BLob
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
do we have to consider iot_type is null and iot_type not null  with partitioned = 'NO' when we select tables. Please advise
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Am a bit confused here. If each partition is in a different table space, I have to write separate scripts for the tables that are partitioned in different tablespaces. Is that right ?
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thank you !