-
exp/imp from 8.0.5 to 8.1.6
can I have a different db_name than the one I am importing
from ???? and can I have different names, location, and size for my tablespaces and db_files,redo logs, control file,etc...???
thanks,
-
Sure. With import you are importing objects, not the database structure. Just create your database, create your tablespaces, create your schema owners, and import schema by schema.
Jeff Hunter
-
does that apply on full database export ????
-
If you have a full export, you can import schema by schema. If you do a full import, it will create tablespaces, and stuff for you. I recommended schema by schema because you wanted to change the physical structure of the database.
Jeff Hunter
-
new database
You can precreate the tablespaces and specify ignore=y. This will "ignore" the create tablespace statements as long as the tablespace names are the same.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|