oracle 相关操作

// 创建用户并且赋予权限
create user aaa identified by aaa;
grant dba to aaa;
grant connect,resource to aaa;

// 创建表空间
CREATE TABLESPACE aaa LOGGING DATAFILE '/home/oracle/oradata/oracle/aaa.dbf' SIZE 3096M AUTOEXTEND ON NEXT 1024M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;

// 授权用户表空间
alter user aaa default tablespace aaa;

// 删除表空间和数据文件
drop tablespace TRAFFIC including contents and datafiles;


// 执行sql文件
@/home/oracle/aaa.sql;
--乱码问题       export NLS_LANG=AMERICAN_AMERICA.AL32UTF8