DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2000
    New York,U.S.A.
    Hi, all
    Is there any way just to export packages,functions,triggers,views etc but without tables and its data? what is the proper syntax? Thanks for help.

  2. #2
    Join Date
    Oct 2000
    The best thing will be to use a Schema generation tool and use Reverse Engineering to create the SQL for the functions, procedures, triggers etc.

    But if you don't have such a tool and must use Export/Import then you will have to export at least at USER level to export the procedures, functions etc.

    There is a parameter ROWS that you can set to 'N' so that it does not export the table data.

    It will still export the table definitions though.

    In the database where you want to import, it will create the empty tables if they don't already exist (in this case you can drop those tables after the import)

    If the tables already exist it will show error (you may set IGNORE=Y to ignor esuch errors) and import the procedures, functions triggers etc.

    - Rajeev
    Rajeev Suri

  3. #3
    Join Date
    Jul 2000
    You can create a script to create these objects from the data dictionary views, USER_SOURCE, USER_VIEWS and USER_TRIGGERS.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.