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;
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;