|
-
You can do an alternate
do an import where in the all the DDL would go into a file, edit the file and run the same into the new schema.I know this would be a tedious task, i am just giving you an option...
imp username/password INDEXFILE=
where file in indexfile parameter would contain all the DDL's, edit it to include the new tablespace and execute the same in the new schema
regards
anandkl
anandkl
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
|
Reply With Quote