IMP tablepsaces also ?

[vr76413]

Hi all
I did an EXP using System account with FULL=Y option. Now when i did IMP on to Target database with FULL=Y using System account, it DIDNOT copy any TABLESPACE into Target Database....

So my question is..
What do i need to do in IMP command so that it copies Tablsepaces also from Source DB to Target DB...Basically i need all Data, Tables, Tablespaces, Users, Index, Schemas...etc to be copied from Sorce to Target DB.

any help is Appreciated.

 

[flstffatboy]

VR76413,

I'm curious did you create a log of the export? If so are there any errors in the log?

 

[flstffatboy]

Just thought of something else if the source and target DB's are on the same box you will need to create the tablespaces in advance of the imp to the target DB. When the import is running the create tablespace commands will error but the imp will create users then their objects into the correct tablespaces.

flstffatboy