Linux中的Oracle数据导入

imp hw_sgnq/hw_sgnq file=/u01/yj.dmp grants=y;

imp gx/gx file=expdat_jzwx.dmp grants=y;

imp \'hw_sgnq/hw_sgnq as sysdba\' file=/u01/yj.dmp FULL=Y grants=y

-- USER SQL
SQL>CREATE USER oracle IDENTIFIED BY zyx ;

-- ROLES
SQL>GRANT "RESOURCE" TO oracle WITH ADMIN OPTION;
SQL>GRANT "CONNECT" TO oracle WITH ADMIN OPTION;
SQL>ALTER USER oracle DEFAULT ROLE "RESOURCE","CONNECT";
SQL>GRANT IMP_FULL_DATABASE to oracle;
SQL>GRANT DBA to oracle;

-- SYSTEM PRIVILEGES

-- QUOTAS

imp \'hw_sgnq/hw_sgnq as sysdba\' file=/u01/yj.dmp FULL=Y grants=y commit=y ignore=y