1)
exp user/password@BeiJingOracle file=raw_data.dmp tables=DATA_RAWDATA
2)
# mkdir /home/oracle/u1
# sqlplus user/password@BeiJingOracle
>create or replace directory DPDATA1 as '/home/oracle/u1';
>grant read, write on directory DPDATA1 to datasearch;
>declare
fhandle utl_file.file_type;
begin
fhandle := utl_file.fopen('DPDATA1', 'example.txt', 'w');
utl_file.put_line(fhandle , 'eygle test write one');
utl_file.put_line(fhandle , 'eygle test write two');
utl_file.fclose(fhandle);
end;
/
>expdp datasearch/datasearch tables=DATA_CLIENT directory=DPDATA1 dumpfile=test.dmp job_name=DATA_CLIENT_EXPORT
