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
- 5143 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 define Data Block size in Oracle?
How the space utilisation takes place within rollback segments?
What is PGA?
How to implement the multiple control files for an existing database ?
How will you monitor rollback segment status ?
What is Shared Pool?
What is an Integrity Constrains in Oracle?
How free extents are managed in Ver 6.0 and Ver 7.0 ?
What is meant by Redo Log file mirrorring ? How it can be achieved?
What is the OPTIMAL parameter ?
What is the functionality of SYSTEM table space ?
What is meant by redo log buffer ?
Oracle General 
