1、先安裝好11g,創(chuàng)建表空間再創(chuàng)建用戶。
CREATE TABLESPACE TS1 DATAFILE '/data1/oracle/ts1.dbf' SIZE 512M AUTOEXTEND ON NEXT 256M MAXSIZE UNLIMITED;
create user user01 identified by 123456 default tablespace TS1;
grant dba,resource,connect to user01;
2、dmp是備份文件，一般會(huì)包含用戶和表空間信息
3、dmp文件是如果用exp導(dǎo)出的，就用imp導(dǎo)入
imp user01/123456 file=a.dmp FULL=y
4、dmp文件是如果用expdp導(dǎo)出的，就用impdp導(dǎo)入
create or replace directory expdp_dir1 as '/data1/backup';
grant read,write on directory expdp_dir1 to user01;
或者grant read,write on directory expdp_dir1 to public;
例如：impdp user01/123456 directory=expdp_dir1 dumpfile=a.dmp logfile=impdp.log
5、查詢sqlplus /nolog
conn user01/123456
select * from tab;