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
