DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: export utility

  1. #1
    Join Date
    Jan 2006

    export utility

    Hi All,

    We are doing logical backup using export utility .Is any option to restrict the export on particular tables.

    That is we have 120 tables in which we have to export only 100 tables.Is anyother way to export those tables other than the option tables=(t1,t2)


  2. #2
    Join Date
    Dec 2000
    Ljubljana, Slovenia
    Yes, there is:

    Apply an appropriate security policy (package SYS.DBMS_RLS) to those 20 tables you don't want to export and apply the appropriate security context (for example, add the predicate "WHERE 1=2" for those tables) to the exporting user. That way, the metadata for those 20 tables will still be exported, but their actual data won't.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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

By using this site, you agree to the Privacy Policy