Hi all,
I have a problem with import certain specified tables using expdp command in oracle 10g.
Here's what i did to set it up:
I logged in as sysdba and ran the following commands
create or replace directory dumpdir as 'c:\test\';
grant read,write on directory dumpdir to test;
Then i went to the command prompt on my windows box and tried the following
expdp test/password@local directory=dumpdir dumpfile=test.dmp tables=dept.geocode, dept.people parallel=4
and
expdp test/password@local directory=dumpdir dumpfile=test.dmp tables=dept.geocode, dept.people parallel=4
when i ran these commands it didn't give me any errors. It just displayed the following and ended
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
C:\Documents and Settings\myname>
I don't know what else to do. Can someone help me figure out how to get this to work?