Import and Export commands for databases in oracle

This article introduces how to import and export elasticsearch. For more information, see.

This article introduces how to import and export elasticsearch. For more information, see.

This article introduces how to import and export elasticsearch. For more information, see.

The Code is as follows:
ORACLE_192.168.28.1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.28.1) (PORT = 1521 )) ) (CONNECT_DATA = (SERVICE_NAME = oracle11) ) ) ORACLE_192.168.28.2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.28.2) (PORT = 1521 )) ) (CONNECT_DATA = (SERVICE_NAME = oracle22) ) )

1. Import and export commands

2. Database Table Clob and Blob Import and Export commands

Exp database username/password @ configuration name file = output file path log = log file Path tables = (Database Table Name) query = "query condition"

Imp database username/password @ configuration name file = input file path log = log file Path tables = (Database Table Name) ignore = y

The Code is as follows:
Exp test/test@ORACLE_192.168.28.1 file = c: 11.dmp log = c: 11.log tables = (table1) query = "where createdby = 'sysadmin' and to_char (createtime, 'yyyy-MM-DD ') = '1970-05-17 '" Imp dev/dev@ORACLE_192.168.28.2 file = c: 11.dmp log = c: 121.log tables = (table1) ignore = y

Run cmd.exe. Note that the query field is used"

Execute exp first and then imp