Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    1,074

    Unanswered: getting INSTEAD OF trigger from expdp

    If I import an entire schema I can get all of the VIEWS and their INSTEAD OF triggers installed. How can I specify just a single view and it's INSTEAD OF trigger? The following didn't insert anything into my SQLFILE:

    Code:
    [oracle@orabx2 transport]$ impdp forbesc@dev tables=INSLIC.UC_COMPANY_NAMES_V directory=DPUMP_DIR_NAS dumpfile=expdpprodfull_20060304.dmp SQLFILE=uc_company_names_v.sql
    file contained

    Code:
    [oracle@orabx24 transport]$ more uc_company_names_v.sql 
    -- CONNECT FORBESC
    -Chuck

  2. #2
    Join Date
    Dec 2003
    Posts
    1,074
    Got it

    Code:
    [oracle@orabx2 transport]$ impdp forbesc@dev directory=DPUMP_DIR_NAS dumpfile=expdpprodfull_20060304.dmp SQLFILE=uc_company_names_v.sql INCLUDE=VIEW schemas=INSLIC

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •