new database

[ocpdude]

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,

[marist89]

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.

[ocpdude]

does that apply on full database export ????

[marist89]

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.

[mhaller]

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.