Hello,
i'm novic in Oracle server and i have the problem with exoporting table
from one db to another:
In the first DB is table in tablespace system and owner is i.e. test1 (
its default tablespace is system).
In the second DB i want to import table to the user test2, which
default tablespace is user.
The problem is: exporting table ( but it's the same for more tables) has
sql command create table xxx (.......) in tablespace system and that
failed, because in the second DB user test2 has no permissins to write
to the system tablespace.
In export procedure i can't say to export it without saying what
tablespace it was.
In administrators guide is written:
If a user’s quotas allow it, the user’s tables are imported into the
same
tablespace from which they were exported. However, if the tablespace
no longer exists or the user does not have the necessary quota, the
system uses the default tablespace for that user.
But it doesn't work, it alaways wants to me to load it to the system
tablespace.
Is there any straight solution?
Thanx
Vaclav
Received on Fri Dec 11 1998 - 00:00:00 CST
