Re: Move a table from system to another tablespace

From: <michael_bialik_at_my-deja.com>
Date: Sun, 23 Jan 2000 20:47:15 GMT
Message-ID: <86fpcf$3nm$1@nnrp1.deja.com>

Hi.

Export to blame.
During EXPORT table definitions are exported with original ( SYSTEM in your case ) tablespace.
You have to create all tables manually in a new tablespace and only afterward IMPORT data only.

HTH. Michael.

In article <86f5ej$ls5$1_at_nnrp1.deja.com>, braccos_at_my-deja.com wrote:
> I have a user that used to create the tables
> inside the System TBS.
> I need to move the tables from System to the new
> one.
> We tried making an export, dropping the user,
> creating the user with default TBS the new one,
> reimported all... And the miracle was that before
> the import all the objects were in the new TBS,
> after the import all the tables and data were on
> System (AGAIN!??!?!).
> The quota were right, the rest also...Now, any
> other idea?? The user has the dba granted....
> Should it be the problem?? I think so, the
> problem is that my user is using the dba
> privileges to use Oracle and at this time I can't
> revoke them.
>
> Please let me know.
>
> Thanks a lot in advance.
>
> Regards
>
> Stefano Bracco
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Jan 23 2000 - 14:47:15 CST