Hi, Folks:

I have one question about the tablespace convertation.

I have one schema named A. There are 100 tables
created based on Tablespace B and 200 indexes on
Tablespace C.

To convert the Tablespace B & C from dictionary-manage
to Local-manage. I can drop all indexes and re-create the
Tablespace C as local-manage tablespace. That's workable.

However, I don't know how to convert the Tablespace B
to loca-manage tablespace. What I thought first is to export
all data, drop the B including contents, re-create B as local-
manage tablespace. Import data back.

But when I import the data, the Table structure is not
match. It failed.

Now, I am thinking about re-create those 100 tables
again on the new local-manage tablespace B.

But I don't know is there any script can allow me to
re-create all the tables under Schema A.

Is there anyone can help me with this ? Thanks.


Ke