What change the registry I also changed!

CodePudding user response:

EXPDP command you use is correct? Directories are not set
Baidu check command how to use

CodePudding user response:

The create or replace directory DMP as' d:/DMP ';

Expdp zftang/zftang @ zftang directory=DMP dumpfile=test. The DMP

CodePudding user response:

Under the wei-so:

 1, create a DIRECTORY 
Create the directory dir_dp as' D:/oracle/dir_dp '; 
2, the authorization 
Grant read, write on directory dir_dp zftang), 
- check the catalog and permissions 
The SELECT privilege, directory_name DIRECTORY_PATH FROM user_tab_privs t, all_directories d 
WHERE t.t able_name (+)=d.d irectory_name ORDER BY 2, 1; 
3, the implementation of export 
Expdp zftang/zftang @ fgisdb schemas=zftang directory=dir_dp dumpfile=expdp_test1. DMP logfile=expdp_test1. The log. 

CodePudding user response:

But can use the automatic backup before, now also used.

CodePudding user response:

CodePudding user response:

@ pobaby

CodePudding user response:

You try the EXP
This command is straightforward

CodePudding user response:

refer to 7th floor sych888 response:

you try the EXP
This command is simpler

I am a food, a great god please tell me how to operate w thank you

CodePudding user response:

Exp userid=username/password @! TNSNAME service name owner=username flle='d: \ tt. DMP log=' d: \ tt. The log '

CodePudding user response:

Switch Sql>
1, create the directory Test as' D: \ Test \ DMP ';
2, switch to the command window to perform expdp user/pw @ service name schemas=user directory=Test dumpfile=Test. The DMP logfile=Test. The log.

CodePudding user response:

references 9 f sych888 response:

exp userid=username/password @! TNSNAME service name owner user name flle=='d: \ tt. DMP log=' d: \ tt. The log

Is exp userid=hyfd/hyfd2016 @! TNSNAMEoracle owner=administrator file='d: \ tt. DMP log=' d: \ tt. The log '
I send this direct paste is there a problem?

CodePudding user response:

The

references to the tenth floor A_A_apan response:

switch Sql>
1, create the directory Test as' D: \ Test \ DMP ';
2, switch to the command window to perform expdp user/pw @ service name schemas=user directory=Test dumpfile=Test. The DMP logfile=Test. The log.

Can I use PLSQL connection,

CodePudding user response:

The

refer to 12 floor lxp970601 reply:

Quote: reference to the tenth floor A_A_apan response:

Switch Sql>
1, create the directory Test as' D: \ Test \ DMP ';
2, switch to the command window to perform expdp user/pw @ service name schemas=user directory=Test dumpfile=Test. The DMP logfile=Test. The log.

Can I use PLSQL connection,

Haven't done???

CodePudding user response:

11 references lxp970601 response:

Quote: references 9 f sych888 response:

Exp userid=username/password @! TNSNAME service name owner user name flle=='d: \ tt. DMP log=' d: \ tt. The log

Is exp userid=hyfd/hyfd2016 @! TNSNAMEoracle owner=administrator file='d: \ tt. DMP log=' d: \ tt. The log '
I send this direct paste is there a problem?

Surely there is a problem, the service name is your configuration within the TNSNAME file
Another OWNER should not ADMINISTRATOR, specify when you export data also ORACLE user
For example: hyfd

CodePudding user response:

If PLSQL can connect, it should be to the client

CodePudding user response:

reference 15 floor student_2008 response:

can even if PLSQL, it should be the client problem

Can even, the client how to solve the problem

CodePudding user response:

On the 14th floor sych888

reference response:

Quote: reference 11 floor lxp970601 response:

Quote: references 9 floor sych888 response:

Exp userid=username/password @! TNSNAME service name owner user name flle=='d: \ tt. DMP log=' d: \ tt. The log

Is exp userid=hyfd/hyfd2016 @! TNSNAMEoracle owner=administrator file='d: \ tt. DMP log=' d: \ tt. The log '
I send this direct paste is there a problem?

Surely there is a problem, the service name is your configuration within the TNSNAME file
Another OWNER should not ADMINISTRATOR, specify when you export data also ORACLE user
Such as: hyfd

I give you the TNS configuration file to the person I have ever seen, others say that there is no problem. ORACLR_CONNECTION_DATA=https://bbs.csdn.net/topics/
(the DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=IPC) (KEY=EXTPROC1521))
)
(CONNECT_DATA=
https://bbs.csdn.net/topics/(SID=CLRExtProc)
(the PRESENTATION=RO)
)
)

HYFD=
(the DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(TCP) PROTOCOL=(HOST=127.0.0.1) (1521) PORT=)
)
(CONNECT_DATA=
https://bbs.csdn.net/topics/nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull