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
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
Oracle Database
Last Comment
d27m11y d27m11y
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
How about CLOb and BLob
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
do we have to consider iot_type is null and iot_type not null with partitioned = 'NO' when we select tables. Please advise
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you !