oracle 导入导出

imp gstest/gstest@172.16.3.2-linuxBaosong FULL=Y file=d:/gstest.dmp
fromuser=gstest touser=gstest

exp gstest/gstest@172.16.3.2-linuxBaosong file=d:/gstest.dmp


***********************************************


--tablespace
CREATE TABLESPACE tedaoins
DATAFILE '/opt/oracle/oradata/orcl/tedaoins01.dbf'
SIZE 2G
EXTENT MANAGEMENT LOCAL AUTOALLOCATE; 

ALTER TABLESPACE tedaoins
ADD DATAFILE '/opt/oracle/oradata/orcl/tedaoins02.dbf'
SIZE 2G
                                            

--user
-- Create the user
create user GSTEST
  identified by "GSTEST"
  default tablespace GSTEST
  temporary tablespace TEMP
  profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to GSTEST;
grant dba to GSTEST;
grant resource to GSTEST;
-- Grant/Revoke system privileges
grant create procedure to GSTEST;
grant create tablespace to GSTEST;
grant create view to GSTEST;
grant unlimited tablespace to GSTEST;