Oracle exports, imports all data from a user (including tables, views, stored procedures ...) ）

Prerequisite: Under the cmd command

Export command: EXP username/password @ database owner= user name file= file storage path (for example: F:\ABCD.DMP)

TEST: Exp zm/[email protected] OWNER=ZM file=f\abcd.dmp

Import Command: IMP username/password @ database fromuser= user name touser= user name File=d:\cu.dmp ignore=y

IMP: Command type

cu/[email protected]: Imported Database Login (user name/password @ database)

Fromuser: Specified user of the file

Touser: Specify a user to import into the currently logged-on database

File: Data files that need to be imported

Ignore: Whether to ignore creation errors

Test: Imp zm/[email protected] fromuser=zm touser=szzm file=f:\test.dmp ignore=y

Oracle exports, imports all data from a user (including tables, views, stored procedures ...) ）