I'm searching info about that commands (imp and exp).
I have guessed something,but I wonder if I can import one database from one tablespace to another one.Because I got it,in a different schema,but the refered tablespace is the original one...
Thanks
04-17-2002, 09:11 AM
aarroyob
In the command prompt type:
exp help=yes
imp help=yes
Cheers
Angel
04-17-2002, 10:30 AM
jamoji
Thanks,but what I want to find out is how can I import the objects to a new tablespace,in my new schema...
Thanks
04-17-2002, 10:39 AM
aarroyob
If you have the export of the first schema, then:
1. Assign the new tablespace as default to the new user, then just:
After run the same command with the parameter indexfile=file_you_want
This generate a file with the DLL to create the indexes. Change the tablespace where the indexes were created for the new tablespace you want. Connect as the new user and run the .sql
Hope that helps
Angel
04-17-2002, 11:15 AM
jamoji
Thanks very much...I thought there was another way more direct to do that.Because if you have a huge database,you have to change many times tablespace name in the log file.