-
Hi, I need an export script to export all tables in given tablespaces
does any have a copy?
Rahul Khana
-
wha?
Uh, if you want to export everything you just do an export = full
Do you want to specify which tables and schema to export?
Maybe some more info will help us help you.
- Magnus
-
Spool the output of the following query and then add them into your exp parameter file.
SELECT TABLE_NAME|| ','
FROM DBA_TABLES
WHERE TABLESPACE_NAME='USERS'
AND OWNER='SCOTT';
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
|