oracle数据库基本语法操作

/创建表空间
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