oracle automatically import data can be

Sep 20 posted in Oracle (RSS), 110 views.

Oracle Database automatically import and export, in many places there is a wide range of applications. For example: an Oracle database application system development after the end, if the

To system is installed to the client computer will need to import the initial data to the user's Oracle database.

Recent projects also need to implement the above features, it took time to search experiment, finishing as follows:

To install the initial data should first export the file initial.dmp, and then installed on the client computing on the Oracle, and then execute the batch file

impInitialData.bat (the same directory with the batch file also createuser.sql, initial.dmp two files).

impInitialData.bat reads as follows:

@ echo off

sqlplus system / manager @ createuser

imp system / manager file = initial.dmp fromuser = initialuser

touser = initialuser ignore = y

Above createuser is a sql file extension. With a batch file on the same directory. Which reads:

create user initialuser identified by test;

grant dba, resource, connect to initialuser;

exit;

Added: delete user with: drop user powercc cascade; which powercc the user name.

Briefly explain: @ echo off command after that its not in the command prompt window is displayed. sqlplus as a tool for the Oracle program,

Must first install Oracle before you can use. system / manager for Oracle in a default administrator account, if it is locked or changed password can not be

Used, you can use any other account / password to replace. @ createuser said that the implementation of createuser.sql file. The sql file, create user

xx identified by yy; that yy to create a password for the user xx. grant dba, resource, connect to xx; said the license to the user

xx dba, resource, connect privileges. imp command to import the data, followed by the parameters file that you want to import the database file; fromuser

Indicated that the original export of the database file the user name; touser database that you want to import the user name; ignore that ignore the error.

Approximate method is so that you can then add other commands to perform more complex operations.