- ALTER SYSTEM DISABLE RESTRICTED SESSION;
(权限)
create tablespacedcenter datafile 'd:\Database\oraclexe\oradata\XE\DCENTER.dbf' size 50Mautoextend on next 10M maxsize unlimited logging extent management localautoallocate segment space management auto;
(创建表空间)
Oracle本地数据库导入dmp数据
开始->运行->输入cmd->
imp sys (oarcle本地名)/123456(密码)file=d:\work\dmp\1.dmp full=y
imp sys/123456file=d:\work\dmp\1.dmp full=y