There are seven or eight oracle10G database applications, I set up a special machine for long-distance oracle10G database backup,.net configuration manager with exp, command in my after the special machines used for backup oracle10G database backup database, there is something wrong with server a while ago, installed in the vm workstation oracle10G server, configure the.net exp command is used to derive the database manager after failure, please god to look at, thank you!!!!!

CodePudding user response:

CodePudding user response:

What version of the database, use expdp export import a try

CodePudding user response:

Answer: this question is to use the high version of the exp to export the low version of the data, such as your local data is 10.1, and was going to export data from 9 I,
Method 1: directly to the need to export the machine to do export, and then copy the file to come over,
Method 2: to install an Oracle client, version or higher than the version on the local machine,

Second, solutions and matters needing attention
The above two methods all can be solved, but there is method 1 May not have permission to enter the remote machine, some problems in the method 2,
There is a kind of method is derived. The form of SQL, this method is not influenced by version,

Three, note
It is important to note that if the table has a BLOB or CLOB fields, cannot use. The form of SQL,

CodePudding user response:

reference 1st floor js14982 response:

.

CodePudding user response:

refer to the second floor js14982 response:

what version of the database, use expdp export import try

Are oracle10G second version, 10.0.2.

CodePudding user response:

reference js14982 reply: 3/f

answer: this question is to use the high version of the exp to export the low version of the data, such as your local data is 10.1, and was going to export data from 9 I,
Method 1: directly to the need to export the machine to do export, and then copy the file to come over,
Method 2: to install an Oracle client, version or higher than the version on the local machine,

Second, solutions and matters needing attention
The above two methods all can be solved, but there is method 1 May not have permission to enter the remote machine, some problems in the method 2,
There is a kind of method is derived. The form of SQL, this method is not influenced by version,

Three, note
It is important to note that if the table has a BLOB or CLOB fields, cannot use. SQL is deduced, in the form of

Are 10.0.2, used is the database on the server side, whether light.net configuration on the client manager not line!!

CodePudding user response:

May be, expdp this way?

CodePudding user response:

Is that you can access for PLSQL do not EXP export in other cities,

CodePudding user response:

refer to 7th floor js14982 response:

might be, expdp this way?

Also at the same mistake

My exp in batch convert into expdp

CodePudding user response:

I change after expdp hints parameter error "file"

Don't expdp and exp command format is different,,

CodePudding user response:

The fault is not the same? An error to look at it?

CodePudding user response:

Expdp user/PWD dumpfile=...

CodePudding user response:

The

refer to 12 floor js14982 reply:

expdp user/PWD dumpfile=...

Ok, I try, I can't continue to reply!

CodePudding user response:

Individual can use EXP command different export, some still won't do prompt error!!!!!

CodePudding user response:

That mistake or version of the problem, I switch to 9 I!!