imp command in oracle 11g

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 *************************************************************************************************************** ***** Oracle

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

Explain the Oracle imp exp command, impexp How to import dmp database files in oracle? Importing and exporting oracle Data imp/exp is equivalent to restoring and backing up oracle data.

/manager parfile = bible_tables.par Bible_tables.par parameter file: # Import the sample tables used for the Oracle8i Database Administrator's Bible. fromuser = seapark touser = seapark_copy file = seapark log = seapark_import 8. incremental Import Imp system./manager inctype = rectore full = y file = Oracle imp/exp C: Documents and Settingsadministrator> exp hel

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