oracle 导入导出命令

create tablespace data_tqmes datafile 'D:\oraclexe\product\10.2.0\oradata\xe\data_tqmes.dbf' 
size 1024m autoextend on next 50M maxsize unlimited;
 
create user tqmesuser identified by "tqmesuser" default tablespace data_tqmes;
grant connect,dba,resource to tqmesuser; 
grant unlimited tablespace to tqmesuser;

  

exp tqmesuser/tqmesuser@xe file=d:\tqmes.dmp owner=(tqmesuser)

imp tqmesuser/tqmesuser@xe full=y file=d:\tqmes.dmp ignore=y 



SQL>select * from V$NLS_PARAMETERS
SQL>conn / as sysdba
SQL>shutdown immediate
SQL>STARTUP MOUNT
SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION
SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0
SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0
SQL>ALTER DATABASE OPEN
SQL>ALTER DATABASE CHARACTER SET ZHS16GBK
SQL>ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK
SQL>SHUTDOWN IMMEDIATE
SQL>STARTUP