views:

194

answers:

0

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?