9 Replies Latest reply: Feb 18, 2013 2:33 AM by 941949 RSS

    export issue

    941949
      dear all,
      i m a newbie and need ur precious help.i have oracle db 10.2.0.3 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?