如何从oracle的dmp文件中还原数据(国外英语资料).docVIP

如何从oracle的dmp文件中还原数据(国外英语资料) Xuehongliang -by-12 August 2007 16:27 Recent use of restore data from oracles DMP file Without this information, collected some online, believe in these data, we can successfully DMP file way to restore back from the command line So here Im using the version of oracle10g, and my machine is 512 memory, and its a little bit difficult to run oracles web management program, so Im going to choose the command line, Following my installation, oracle reports Enterprise Manager Database Control URL - (orcl) : http://localhost:1158/em The database configuration file has been installed E: oracleproduct10.2.0. The other selected installation components are also installed E: oracleproduct10.2.0 db_1. ISQL * Plus the URL is: http://localhost:5560/isqlplus The iSQL * Plus DBA URL is: http://localhost: 5560/isqlplus/dba Lets take a look at how to accomplish this task First, start the service (if the database is in the boot state, skip this step) Open the command line to execute the following statement Net start OracleServiceORCL Net start OracleOraDb10g_home2TNSListener Net start OracleOraDb10g_home2iSQL * Plus The above approach is to start the service in Windows services and apply the following statements when the Windows service fails to start the database instance The set is = former Oradim - startup - sid former Up sqlplus internal/oracle startup The second is to clean up the trace that was done before, if we had been restored in the database, lets clean up the trace, / / remove users Drop the user XXXX cascade; / / delete table Spaces The drop in tablespace XXXX. / / delete database files E: XXXXXX. DBF Third, then, when the preparation is done, we can begin to restore it / / create users The CREATE USER username is IDENTIFIED BY password DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP / / give user permission Grant connect, the resource, the dba to XXXX / / create the table space, and specify the file name, and the size CREATE SMALLFILE TABLES