/创建表空间
create tablespace NCSEITZDATA datafile 'NCSEITZDATA.dbf' size 50M
autoextend on next 100M maxsize unlimited
default storage(initial 128K next 128K minextents 5 maxextents unlimited)
/指定工作空间创建用户
create user ncseitz identified by "123456" default tablespace NCSEITZDATA
/授予当前用户权限
grant dba,connect,resource,select any table,delete any table,
update any table,insert any table to ncseitz
/设置会话
ALTER SYSTEM SET processes = 500 SCOPE=SPFILE;
/备份数据库
exp **/**@*** file=***.dmp log=***.log rows=Y owner=**
/导入数据库
imp sa/missu@orcl fromuser=saback touser=sa file=e:\SABACK20090309.dmp log=e:\SABACK20090309.log rows=Y
create tablespace NCSEITZDATA datafile 'NCSEITZDATA.dbf' size 50M
autoextend on next 100M maxsize unlimited
default storage(initial 128K next 128K minextents 5 maxextents unlimited)
/指定工作空间创建用户
create user ncseitz identified by "123456" default tablespace NCSEITZDATA
/授予当前用户权限
grant dba,connect,resource,select any table,delete any table,
update any table,insert any table to ncseitz
/设置会话
ALTER SYSTEM SET processes = 500 SCOPE=SPFILE;
/备份数据库
exp **/**@*** file=***.dmp log=***.log rows=Y owner=**
/导入数据库
imp sa/missu@orcl fromuser=saback touser=sa file=e:\SABACK20090309.dmp log=e:\SABACK20090309.log rows=Y