Realocate Table

[Adilsom Musskop]

Good Afternoon all

I have some tables I wanna realocate from one to anoter tablespace, but not getting 'cause it has fields with data type LONG , but, I need to do it, 'cause another people created this BD and that table are in SYSTEM tablespace.

That's my questio: How can I realocate tables with LONG data type.

I am using Oracle 9i!

Very sincere thanks to all!!

[Thomasps]

Hi

I think it is not possible to move a table with LONG column. You need to

1. Export the table
2. Re-create the table in the required tablespace or change the default tablespace to the target tablespace
3. Import the table.

Thomas

[Adilsom Musskop]

I agree that is a good method, but, let's imagine I have already one hundred tables I want to realocate!! Is there another more simple way to do it??
Anyway, thanks by your answer!!!

[Thomasps]

If you are very much comfortable with MOVE try to move all the tables WOTHout LONG column and user export/Import for LONG column tables.

Or

You can get the list of tables as follows

select object_name
From dba_objects
where owner not in ('SYS', 'SYSTEM') and
object_type='TABLE';

Export all this tables using the TABLE option. So in one step it is over..



Thomas

[Adilsom Musskop]

Good!
MOVE, I have done. I will try to follow other steps.

Really thanks!

Peace to you