Do you want to create a user before impdp is imported?

Write the same as the expdp command, such as the export command: expdp username password schemas=username directory=exp dumpfile=*dmp logfile=

The import command simply replaces expdp with impdp impdp username password schemas=username directory=exp dumpfile=*dmp logfile=

Note: First, transfer from the exported machine to the machine where you want to import the database, e.g. Windows can be placed in the d:imp folder (if the two machines have different operating systems, you need to use binary to transfer the dmp file).

Create an import and export directory in the database where you want to import data.

sql>create directory as 'd:\imp';

3.Import impdp username password schemas=username directory=exp dumpfile=*dmp logfile=

You do not need to create a user, but you need to create a corresponding tablespace.

You don't need to delete it, you can overwrite it automatically. Refer to the following below:

1.There are two import methods: IMP and IMDP.

When importing: If the table already exists, it will tell you that you cannot create the table because the table already exists. At the same time, use the parameter full=yignore=y, which is to import all the data in dmp and insert it into the table.

3.To back up data, run the impuser userfile=d: command to restore the data and run the impuser userfile=d: command.

When importing, use the table exists action=replace parameter to delete and override the table exists action option.

5.To back up data, run the expdpuser userdirectory=dump dirdumpfile=

logfile=on recovery.

Note: Oracle Impdp is a Standard Edition and Enterprise Edition issue. Some functions are not supported in the standard version. It's a good idea to reinstall the enterprise version with the same version, including importing a smaller version.

If you have to use the current library, you can add version= when exporting. If you fail to change it to, try again.

drop user username cascade;I deleted all the tables associated with this and created a new user

1. Repeatedly import existing databases, there are the following two import methods: imp and impdp.

2. When importing imp: If this table already exists, it will tell you that you cannot create this table because the table already exists. At the same time, use the parameter full=yignore=y, which is to import all the data in dmp and insert it into the table.

3. For data backup, use the command: exp user user file=d: full=y to restore the data

imp user/user file=d:\ fromuser=user touser=user full=y ignore=y。

4. When impdp is imported: override the table exists action option after deleting with the parameter table exists action=replace.

5. For data backup, use the command: expdp user user directory=dump dir dumpfile=

logfile= schemas=user job name=exp user schema restoration.

Do you want to clear the records in the original table with the same table name and the same table structure when importing data? Or do you want to delete the original table with the same name, regardless of whether it is of the same table structure or not, and import the new table?

In the case of the former, when impdp is imported, specify Table Exists Action Trincate.

If the latter is the case, when impdp is imported, specify Table Exists Action Replace

Racle's command to import data:

imp username password@service name file=d: buffer=909600 ignore=y full=y commit=y

Note that the username must have already been created, and the import command cannot create a user.

I've done projects like this, and I remember that the data exported by expdp is placed on the server side, and if you use the impdp command to import the database, the table name and schema should be the same.

Things to keep in mind when using expdp and impdp:

EXP and IMP are client-side utilities that can be used both on the client and server.

ExPD and IMDP are server-side utilities that can only be used on the Oracle server, not on the client.

IMP only applies to exp exported files, not expdp exported files; impdp only applies to expdp exported files, not exp exported files.

expdp or impdp command, you can temporarily leave the username password @ instance name as identity out there, and then enter it as prompted, for example:

expdp schemas=scott dumpfile= directory=dpdata1;

1. Create a logical directory, this command will not create a real directory in the operating system, it is best to create it with an administrator such as system.

create directory dpdata1 as 'd:\test\dump';

2. Check the administrator directory (also check whether the operating system exists, because oracle does not care whether the directory exists, if it does not exist, it will be an error).

select * from dba_directories;

3. Give the scott user the operation permission in the specified directory, preferably by the administrator such as system.

grant read,write on directory dpdata1 to scott;

The directory directory is created on the server, the impdp command can only be executed on the server, the file is placed in the directory directory, and the logs will be generated in the directory directory by default.