Re: Move a table from system to another tablespace

1. Export layout only
2. Edit file (it's text) and change from system to your new schema
3. Export Data into a different file
4. Run the first file from SQL*Plus to create the table
5. Import the second file

Brad

On Sun, 23 Jan 2000 20:47:15 GMT, michael_bialik_at_my-deja.com wrote:

>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 - 15:25:17 CST