Re: Export/Import

Hello!

Erwin Dondorp <erwindon_at_wxs.nl> ñîîáùèë â íîâîñòÿõ ñëåäóþùåå:3B5D33F5.C32D5D35_at_wxs.nl...
> Yaroslav Perventsev wrote:
> > AFAIK...
> > import use default user tablespace(if tablespace from which exported
 doesn't
> > exist) .
>
> Sorry, import uses the tablespace that the table was originally in when
> the export was done.

Especially for you. Try this:
In first database:
sqlplus internal <<EOD
create user user1 identified by ... default tablespace ts1; grant ... etc. connect user1_at_db1;
create table test(a number) tablespace ts1; insert into table test select 10 from dual;commit; exit
EOD exp user1/test_at_db1 file=user1.dmp;

In second database:
sqlplus internal <<EOD
create user user2 identified by ... default tablespace ts2; grant ... etc. exit
EOD imp user2/test_at_db2 file=user1.dmp fromuser=user1 touser=user2

Import successful imported test table into tablespace ts2 of user2;

What wrong?!

Best regards!
Yaroslav.

>
> But you can force the tables to be in a certain tablespace by first
> creating all the empty tables in the wanted tablespace.
> On import, the table-create will fail, but that can be ignored.
> After that the data will be loaded into the table.
>
> Erwin
>
> > Zeyad S <sweidanz_at_yahoo.com> ñîîáùèë â íîâîñòÿõ
> > ñëåäóþùåå:3B5D2A27.9DAF7B1C_at_yahoo.com...
> > > Does anyone know how to change the tablespace when you import a
> > > table(s)? I have looked at the manuals and nothing is mentioned in
 this
> > > matter. When exporting a table, Oracle specifies the tablespace name
 in
> > > the create table statement. When importing the table, I would like to
> > > change that tablespace or leave it to the default of the user
 importing
> > > that table.
Received on Tue Jul 24 2001 - 04:08:27 CDT