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