Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Export/import table(s) from one DB to another
This works (tested).
Export userid (e.g. test1) (I was running as system)
Then:
alter user test2 quota 0 on test1_ts;
--don't allow test2
revoke unlimited tablespace from test2;
---(Needed if test2 has "resource")
Finally, import (using fromuser/touser) (again, I was system)
On Fri, 11 Dec 1998 09:20:44 +0100, Vaclav Pavelka <vpavelka_at_derby.cz> 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 Fri Jan 01 1999 - 00:00:00 CST