Home > database >  Oracle database export and import database
Oracle database export and import database

Time:09-23

Oracle need to export the database file:
1) at a random disk or folder shift + right: select here to open a command window
2) input export library instruction: exp herendh/[email protected]: 1522/former file=C: \ software \ 176. DMP owner=herendh;
Resolution is as follows: exp username/password @ network service name the file=XXX. DMP

Oracle: when you need to import the database file
1) run CMD
2) input imp
3) fill in the user name password
4) choose the file location
If abnormal permissions that current you want to import to the object is not the dba permissions, the permissions of the user to dba

CodePudding user response:

Where is the problem

CodePudding user response:

What is your problem? , there is no description!

CodePudding user response:

Oracle pl/SQL also can implement the data of import and export

CodePudding user response:

Thanks for sharing the

CodePudding user response:

I this is not a problem, make a record,

CodePudding user response:

Permission problems,

CodePudding user response:

The study of learning to learn

CodePudding user response:

  • Related