Export / Import

[Igaduma]

Hello All,

2 servers with both same oracle/os(solaris) arch.
I export 1 db to import it in another server.

Previously I always recreated an empty db on the import host and recreated all the underlying tablespaces aka filestructures (using a template I extracted from the exported db) and then started the import.

Somehow I think there must be a way where you just set your oracle base directory & just run the import, feed it the dump file and imp will recreate all necessary tablespaces for you.

Is this possible or do I always have to setup an initial database structure and then import the dump file ?

It's ok with this db since it only has 6 db files & templates do facilitate this but what with really big db's where you can have numerous tablespaces and no template?

Thanks for any info,
Iga

 

[SantaMufasa]

Iga,

I am not aware that importing a "tables-only" or "schema-only" dump file causes the creation of a tablespace, but in the absence of a tablespace the import should be successful, but it uses whatever is the default tablespace of the importing Oracle user (provided s/he has the quota and space available to complete the import).

Mufasa
(aka Dave of Sandy, Utah, USA @ 17:36 (25Mar04) UTC (aka "GMT" and "Zulu"), 10:36 (25Mar04) Mountain Time)