Read Urgent

[mrahul]

Hi, I need an export script to export all tables in given tablespaces

does any have a copy?

[jgmagnus]

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

[tamilselvan]

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';