Today, a friend asked me why 11g exp files cannot be imported into 9I? Due to the incompatibility of exp/imp tools, when importing a database of a higher version to a lower version, you need to use the exp/imp tool of a lower version for import and export. A friend used 9i exp to export 11G data and then import
Now there is a need to use Exp/imp to import 11g of database data into 9i, to solve this problem generally think of three ways of thinking, try (in fact, from the high version of the server to support the low version of the client principle, you can probably guess the use of 9i client to handle the problem)
Method 1: Export imports all use 11g clients
The following problems are frequently encountered during data migration:
1. If the exported file is not valid, the header verification fails;
2. EXP-00056: Oracle error 6550ORA-06550: Line 1, column 41:PLS-00302: component 'set _ no_outlines 'must be declaredORA-06550: Line 1, column 15:PL/SQL: Statement ignoredEXP-00000: Export termination failed
About import and export:
1. The exp command on the clien
Importing and exporting impexpsp2-0734 with Oracle Data today: an Unknown command starts with imp ignoring the default category of the remaining rows. Let's look at the solution below.
Today I'm using Oracle Data to import and export imp/exp sp2-0734: Unknown
Oracle Data Import and Export imp/exp sp2-0734: Unknown command starting with 'Imp... worksp2-0734 und: Unknown command starting with 'Imp ignored the remaining line default classification www.2cto.com should be executed at the cm
Today I'm using Oracle Data to import and export imp/exp sp2-0734: Unknown command starting with \ 'Imp ignores the default classification of the remaining lines, so let's look at the solution below.
Sp2-0734: Unknown command starting with '
Tags: style blog color using file data sp div problemThe backup file was exported from 11g with the exp command, and the above error occurred with IMP Import under 10g, in the case of a lower version of the backup that does not support a higher version, so the use of 11g test, or the above problem.In fact, the size of
Tags: WinForm style blog http tar extBecause like new things, so basically computer development tools are the latest, Oracle also installed 11g R2, but colleague classmate is not 11g R1 is 10G, from here I exported the DMP file in their direction in, all show:IMP-00010: Not a valid export file, header validation failedFor this problem has been distressed, almost
Tags: WinForm style blog http color fileOriginal address: http://www.cnblogs.com/alxc/archive/2011/03/25/1995279.htmlBecause like new things, so basically computer development tools are the latest, Oracle also installed 11g R2, but colleague classmate is not 11g R1 is 10G, from here I exported the DMP file in their direction in, all show:IMP-00010: Not a valid ex
sp2-0734: Unknown command opening ' imp ignored remaining row default category
It should be executed at the DOS command prompt at CMD, not inside the sqlplus ... But the format must be similar to the following:
Imp Personnel_manage/mwq@dbsql full=y file=c:personnel_manage.dmpignore=y
I would like to commemorate my c
Export the table structure with the EXP command and do not export the table data. Simply add a parameter rows=n to the command line. Indicates that table data is not exported.
Exp username/pwd@sid file=d:databak.dmp owner= (user) Rows=n
Importing and exporting Oracle Data imp/exp is equivalent to restoring and backing up oracle data. The exp command can export data from the remote database server to the local dmp file. The imp command can import the dmp file from
Importing and exporting Oracle Data imp/exp is equivalent to restoring and backing up oracle data. The exp command can export data from the remote database server to the local dmp file, and the imp command can import the dmp file
A few days to have nothing to do, just tidy up the next imp/exp
IMP/EXP is an Oracle Import Export command that can be used as a migration of data, EXPDP/IMDP is also a command for Oracle data Import export, and is more efficient
testing and one for formal use.Execution environment: can be executed in SQLPLUS.EXE or DOS (command line),DOS can be executed due to the installation of directory \ora81\bin in Oracle 8i is set to the global path,This directory has EXP.EXE and IMP.EXE files that are used to perform import and export.Oracle is written in Java, I want to SQLPLUS.EXE, EXP. EXE, IMP
Tags: Oracle databaseHow do I import a DMP database file in Oracle?Oracle data import and export imp/exp is equivalent to Oracle data restore and backup. The EXP command can export data from a remote database server to a local DMP
enough. In many cases I have completely removed the table and then imported it. ---------TFX Case One: 9I database Aichannel on 9.3 Import and export operations 1, run GT;GT;CMD2, D:3, CD D:\oracle\ora92\bin4, expaichannel/[ Emailprotected] File=e:\20150714-1.dmp full=y5, impaichannel/[emailprotected] full=y file=e:\ 20150714-1.dmp ignore=y--Single table importimp system/[email protected] file=e:\0825.dmp tables= (acd_code,acd_codetype) ignore=y buff
Create import9.par first, and then run the following command in use: imp parfile =/filepath/import9.par example import9.par:
FROMUSER = TGPMS
TOUSER = TGPMS2 Note: Change the table owner from FROMUSER to TOUSER. Users of FROMUSER and TOUSER can be different)
ROWS = Y
INDEXES = Y
GRANTS = Y
CONSTRAINTS = Y
File =/backup/ctgpc_20030623.dmp log =/backup/import_20030623.log
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
and provide relevant evidence. A staff member will contact you within 5 working days.