How Oracle Exports and imports database tables

How Oracle Exports and imports database tables

Oracle how to export the table in the project after the import of its own database, this is a complete operation, for database backup or to view data validation data on-premises to use, generally I use DOS black window to operate, simple record, after all, good memory than bad pen!

Oracle's IMP/EXP is the equivalent of Oracle data Restore and backup, using this feature we can build two identical databases, one for the formal, a user test, in general, we commonly used to export the server data, local testing, in order to identify problems and correct them.

The IMP command can import a local. dmp file into the corresponding database, whether local or remote

The EXP command can import data from a remote server to local, save to a local folder with. DMP

1. How does Oracle export tables?

Step one: Open cmd;

Step Two: Enter: Exp username/password @ service name tables= table name file= Deposit local DMP Destination Address log= local log destination address

Example:exp test/[email protected] Tables=sys_user file=d:/user.dmp log=d:/user.log

Operation: The following is the DOS window operation, under the D disk can see User.dmp and user.log two files, after the completion of the run can be to the destination address to see if there is a

　　

　2. How does Oracle import tables to a local database?

　　Step one: Open cmd;

Step Two: Enter: IMP username/password buffer=64000 file= database table. DMP Storage Address Ignore=y Full=y

Description: Ignore=y is to ignore the creation error, continue the following operation, Full=y represents the entire contents of the import file, there may be more than one user's content, if the user you are linking by default uses the table space setting is system, the contents of the import file will be directed to the system.

Example:imp test/test buffer=64000 file=d:/user.dmp ignore=y full=y

Run: You can see if the SQL Service is imported and the data is correct, and the DOS operation is as shown.

　　

　　To this entire complete process to end, just at the beginning of the time to others to export a copy of our database table, the two sides of the same, but do not want to how to import, long time easy to forget, write blog good, certainly good, but how to adhere to become the focus, perhaps written very pediatric, When the past a long time to look at their own writing will also feel very funny, I think this may be right, only in this way can find their true level of improvement, for a year of work people are prone to the situation of ambitious, technology, only perseverance to success, now, on the road to success!

Welcome to all the Garden friends to guide The maze, thank you!

　　　

How Oracle Exports and imports database tables