Read Urgent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Read Urgent

  1. #1
    Join Date
    May 2000
    Location
    OHIO
    Posts
    20
    Hi, I need an export script to export all tables in given tablespaces

    does any have a copy?
    Rahul Khana

  2. #2
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Unhappy 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

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    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
  •  



Click Here to Expand Forum to Full Width