Oracle 特别的操作

--创建表空间
create tablespace meng datafile 'D:\tablespaces\meng.ora' size 2000m;
--表空間扩容
alter tablespace meng add datafile 'D:\tablespaces\meng.ora' size 2000m;

--创建自动增长的表空间
create tablespace mengauto datafile 'D:\tablespaces\mengauto.ora' size 2048m autoextend on next 1024m extend management local;

--创建用户
create user meng identified by 123456 default tablespace lyzhxg;

--删除用户
drop user scrott cascade;
--刪除表空間
drop tablespace meng;

--授权
grant create user,drop user,alter user ,create any view,
    drop any view,exp_full_database,imp_full_database, dba,connect,resource,create session to scrott;
--授权访问所有的表
grant select any table to ly_zhcp;
    
--导出
exp scrott/tiger@127.0.0.1:1521/orcl file=E:\test.dmp log=E:\test.log statistics=none (full=y)
--STATISTICS=NONE tables=(ZHXG_ZHCP_STU_SCHSCORE)

--导入dmp
imp scrott/tiger@127.0.0.1/orcl file=E:\test.dmp log=E:\test.log full=y;