Exporting packages,triggers only?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Exporting packages,triggers only?

  1. #1
    Join Date
    Feb 2002
    Posts
    21
    Hi,

    I've done a export from a user and imported that dump into a copy database. Everything has gone across ok, tables/indexes etc.. but some packages and triggers are missing. Is there anyway to just export packages/triggers??

    I know i can do another import using rows=n and ignore=n which will create what failed last time but the file is huge and I just wanted to know the above.

    Thanks in advance

    Kev.

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    i guess you need to use the option u specified.

    regards
    anandkl
    anandkl

  3. #3
    Join Date
    Mar 2002
    Posts
    171
    I don't think you can export triggers or packages independently. The only levels of heirachcial export are: Table Level, User Level and DB Level. So I guess you might want to use the option you have mentioned. I would personally suggest to drop the schema and re-import the whole DMP.

  4. #4
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    Is it an improper import or just a question of compilation?
    PL/SQL Packages etc have to be recompiled after import.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  5. #5
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    As an alternative to import/export, if you are after the material for a given user or set of users, consider a spooled SQL script from dba_source:

    select text from dba_source where owner=username order by name,line.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

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