Re: Export/import table(s) from one DB to another

While importing, use fromuser/touser option, and you should be able to import the table into the default tablespace of the user.

amit

Vaclav Pavelka wrote:

> 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 Tue Dec 15 1998 - 00:00:00 CST