Export/Import
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Export/Import

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Posts
    20

    Talking

    Hai

    1. I have a Oracle database running in a Production system. I need to take the export of only table1, table2, table3 and the associated triggers. How will i specify the trigger in an export command.

    2.If i have a Full database dump how will i import a specific procedure/ trigger only.


    Thanks in advance
    ...Thomas
    Thomas

  2. #2
    Join Date
    Mar 2000
    Location
    india
    Posts
    54
    HI,
    When u r exporting u have triggers option in export command.
    I am not quite sure to exp/imp specific procedures.

  3. #3
    Join Date
    Aug 2000
    Location
    York - England
    Posts
    33
    Hello
    There is NO triggers option when you are exporting
    As far as I know triggers will be exported with a full system export / owner export

    In order to recreate specific triggers you will need to have SHOW=Y on the import command line, redirect this into another file and edit the that file to show the creation statement

    I hope this helps

    Cheers
    :p :p :p

  4. #4
    Join Date
    Oct 2000
    Posts
    33
    It would be much easier using a tool like SQL Navigator. Connect to your production database, look up the triggers etc you need and than do a extract DDL and then save the script and run it on the new schema.

  5. #5
    Join Date
    Sep 2000
    Posts
    14
    Try this -
    SQL> set arraysize 1
    SQL> set long 5000
    SQL> set pages 999
    SQL> col description format a80 word_wrap
    SQL> select * from all_triggers where trigger_name=' ';

  6. #6
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    You can also extract the DDL of a procedure by querying USER_SOURCE by logging in as the user itself. Then you execute it in another schema

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