Interested to Buy Any Domain ? << Click Here >> for more details...
How will you swap objects into a different table space for
an existing database?
- 2 Answers
- 5015 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kd
using expdp to export objects, then using impdp
remap_tablespace to map the objects to another tablespace.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / orawhiz
Export the user
Perform import using the command imp system/manager
file=export.dmp indexfile=newrite.sql. This will create all
definitions into newfile.sql.
Drop necessary objects.
Run the script newfile.sql after altering the tablespaces.
Import from the backup for the necessary objects.
| Is This Answer Correct ? | 0 Yes | 2 No |
How to find the current session sid
What is the function of Lock (LCKn) Process?
How can you find the size of a database?
How the log writer writes the data into database
What is Database Buffers ?
Diference between Oracle 9i and 10G.
What is Shared Pool?
How to define Data Block size in Oracle?
Which parameter in Storage clause will reduce no. of rows per block?
What is use of Rollback Segments In Database ?
THE MAIN CONCEPT OF PROGRAMMIN TYPE?
How will you swap objects into a different table space for an existing database?
Oracle General 
