广西非税：从创建表空间到导入包

create tablespace gxfs datafile 'E:\my_oracle_anzhang\oradata\orcl\gxfs.dbf' size 4096m autoextend on next 10m maxsize unlimited;  

create user gxfs0313 identified by 1 default tablespace gxfs;

grant connect,resource,dba to gxfs0313;

imp gxfs0203/1@orcl file=C:\tools\fstest.dmp full = y

exp mofeni/1@172.17.103.7:1522/orcl11 file=D/:aa.dmp owner=mofeni

 

注意：如果导入的是不本地数据库的话，

就imp gxfs0203/1@172.17.103.230/orcl file=C:\tools\fstest.dmp full = y