Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> can't import to default tablespace
Hi there,
I tried to do an export from 1 machine then import to another machine but the import did not go to the user's default tablespace. What I did was:
export tables of user_A from machine_A default tablespace_A: exp system/manager file=exp.dmp tables=user_A.table1... On machine_B, I created user_A default tablespace_B then I do an import: imp system/manager fromuser=user_A touser=user_A file=...
And the import goes directly into tablespace_A(it was there before) instead of default tablespace_B.
What happen? Many thanks.
Ed
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Apr 05 1999 - 13:00:28 CDT