oracle 备份、还原、导出导入，创建表空间以及用户的命令和语句

-------导入数据的命令

imp ccense/ccense@ora8 file=f:\123.dmp buffer=4196000 ignore=y  fromuser=ccense touser=ccense

exp ccense/ccense@orcl file=d:\nsd.dmp owner=ccense log=d:\export.log

imp syst

------备份的命令

exp ccense/ecardtp@ecardtp file=d:\ecartp.dmp log=e:\log.txt full=y 

exp ccense/ccense@oratp45 file=d:\tp45.dmp log=e:\log.txt owner=ccense tables=(rec_main_consume)

-------重启作业
exec dbms_job.run(作业id号)

mstsc /v:192.168.0.206 /console /admin

--基本表空间
CREATE SMALLFILE TABLESPACE "CCEN"
DATAFILE 'E:\ORADATA\CCEN' SIZE 4000M
 AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT
  LOCAL SEGMENT SPACE MANAGEMENT AUTO
/
--临时表空间
 CREATE SMALLFILE TEMPORARY TABLESPACE "CCEN_TMP"
 TEMPFILE 'E:\ORADATA\ccen_tmp' SIZE 1000M AUTOEXTEND
 ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/
--分区表空间
CREATE SMALLFILE TABLESPACE "DETAIL01"
DATAFILE 'E:\ORADATA\DETAIL01' SIZE 2000M
 AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT
  LOCAL SEGMENT SPACE MANAGEMENT AUTO
/
  --分区表空间
  CREATE SMALLFILE TABLESPACE "DETAIL02"
DATAFILE 'E:\ORADATA\DETAIL02' SIZE 1000M
 AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT
  LOCAL SEGMENT SPACE MANAGEMENT AUTO
/
  --分区表空间
  CREATE SMALLFILE TABLESPACE "DETAIL03"
DATAFILE 'E:\ORADATA\DETAIL03' SIZE 1000M
 AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT
  LOCAL SEGMENT SPACE MANAGEMENT AUTO
/
  --分区表空间
  CREATE SMALLFILE TABLESPACE "DETAIL04"
DATAFILE 'E:\ORADATA\DETAIL04' SIZE 1000M
 AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT
  LOCAL SEGMENT SPACE MANAGEMENT AUTO
/
   CREATE USER "CCENSE"        PROFILE "DEFAULT" IDENTIFIED BY "CCENSE" DEFAULT
   TABLESPACE "CCEN" TEMPORARY TABLESPACE "CCEN_TMP"
/
GRANT CONNECT,RESOURCE,CREATE ANY VIEW TO CCENSE
/
grant EXECUTE   ON DBMS_JOB to CCENSE
/
grant debug connect session to CCENSE
/