-------导入数据的命令
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
/