Oracle创建表空间，导出数据库，导入数据库

create   tablespace   TBS_ATIS   datafile   'D:\oracle\product\10.2.0\oradata\ATIS\TBS_ATIS.dbf'   size   100M  
  autoextend   on   DEFAULT   STORAGE   (   INITIAL   256k   next   256k);;

imp userid=atis/atis@TONGSY full=y file=E:\oracle_backup\Atis.dmp

exp atis/atis@TONGSY file=E:/oracle_backup/atis.dmp log=E:/oracle_backup/atis.log grants=Y

创建同义词
CREATE PUBLIC SYNONYM 摄像机 FOR gis.摄像机1; 

 

create user atis identified by atis;
grant CONNECT to atis;
grant DBA to atis;
grant create any table to atis;
grant insert any table to atis;
grant delete any table to atis;
grant select any table to atis;
grant drop any table to atis;
grant under any table to atis;
grant alter any table to atis;
grant update any table to atis;
grant comment any table to atis;
grant unlimited tablespace to atis;
commit;