9 Replies Latest reply on Feb 18, 2013 8:33 AM by 941949

    export issue

      dear all,
      i m a newbie and need ur precious help.i have oracle db and os RHEL 5.7 .i want to export 65 objects (includes tables,synonyms,indexes,packges,trigger and views)of a user .these object starting with prefix 'DEP'
      i wrote the following command on linux to export these 65 objects starting with prefix DEP but this below command exports all objects of the user.
      please help.thanks

      ]$ exp scott/tiger file=/opt/oracle/expscott.dmp log=/opt/oracle/expscott.log tables like'DEP%';

      is this 'tables like DEP%' correct?