oracle 导入 log,如何从dmp文件和日志文件导入Oracle数据库？

所有这些和平的代码放入* .bat文件并一次运行：

我在oracle中创build用户的代码。 crate_drop_user.sql文件

drop user "USER" cascade; DROP TABLESPACE "USER"; CREATE TABLESPACE USER DATAFILE 'D:\ORA_DATA\ORA10\USER.ORA' SIZE 10M REUSE AUTOEXTEND ON NEXT 5M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO / CREATE TEMPORARY TABLESPACE "USER_TEMP" TEMPFILE 'D:\ORA_DATA\ORA10\USER_TEMP.ORA' SIZE 10M REUSE AUTOEXTEND ON NEXT 5M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M / CREATE USER "USER" PROFILE "DEFAULT" IDENTIFIED BY "user_password" DEFAULT TABLESPACE "USER" TEMPORARY TABLESPACE "USER_TEMP" / alter user USER quota unlimited on "USER"; GRANT CREATE PROCEDURE TO "USER"; GRANT CREATE PUBLIC SYNONYM TO "USER"; GRANT CREATE SEQUENCE TO "USER"; GRANT CREATE SNAPSHOT TO "USER"; GRANT CREATE SYNONYM TO "USER"; GRANT CREATE TABLE TO "USER"; GRANT CREATE TRIGGER TO "USER"; GRANT CREATE VIEW TO "USER"; GRANT "CONNECT" TO "USER"; GRANT SELECT ANY DICTIONARY to "USER"; GRANT CREATE TYPE TO "USER";

创build文件import.bat并把它放在这里：

SQLPLUS SYSTEM/systempassword@ORA_alias @"crate_drop_user.SQL" IMP SYSTEM/systempassword@ORA_alias FILE=user.DMP FROMUSER=user TOUSER=user GRANTS=Y log =user.log

要小心，如果你将从一个用户导入到另一个。 例如，如果您有名为user1的用户，并且您将导入到user2，则可能会失去所有的权限，因此您必须重新创build该用户。

祝你好运，伊万