Realocate Table

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!!

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

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!!!

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

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

Really thanks!

Peace to you