-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|