Export to local Pc

[maxzsim]

Hi ,

i am running the pl/sql developer client and can i execute the export command from the command prompt ?

i have tried the following but i gave me errors :
export mart1/password1 file=test.dmp log=test1.log tables=mytbl ROWS=N indexes=Y;
Unknown object: mart1/password1 file=test.dmp log=test1.log tables=mytbl ROWS=N indexes=Y

1. Can pl/sql developer exports to my local PC for those files ?

2. Can pl/sql developer executes the exports/imports command?

pls advise

tks & rgds

 

[Marco Kalter]

The Oracle exp utility expects a "USERID=" before the username/password:

exp userid=mart1/password1 file=test.dmp log=test1.log tables=mytbl ROWS=N indexes=Y

 

[maxzsim]

Hi,

Have managed to export using Oracle utility program but output is not very neat.

tk you

tks & rgds