
P263
10.1
CONN scott/tiger@orcl
DROP TABLE example;
CREATE TABLE example(
  col1 number(3), 
  col2 varchar2(10));
SQLLDR scott/tiger@orcl control=d:\data\exam_loader.ctl
SELECT * FROM example;
example.dat
001,cd,
0002,fghi,
00003,lmn,
1, "pqrs",
0005,uvwx,
exam_loader.ctl
LOAD DATA
INFILE 'd:\data\example.dat'
INTO TABLE example
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(col1, col2)

P264
10.2
CONN scott/tiger@orcl
SET LINESIZE 100
SET PAGESIZE 100
SPOOL d:\data\emp_loader.dat
SELECT * FROM emp;
SPOOL OFF
DELETE FROM emp;
COMMIT;
d:\data\emp_loader.ctl
    OPTIONS (SKIP=2, LOAD=5 )
    LOAD DATA
    INFILE 'd:\data\emp_loader.dat'
    BADFILE 'd:\data\emp_loader.bad'
    DISCARDFILE 'd:\data\emp_loader.dsc'
    APPEND
    INTO TABLE emp
    (
       empno  POSITION(1:10),
       ename  POSITION(12:21),
       job    POSITION(23:31),
       mgr    POSITION(33:42),
       hiredate POSITION(44:57),
       sal    POSITION(58:68),
       comm   POSITION(70:79),
       deptno POSITION(81:90)
    )
SQLLDR scott/tiger@orcl control=d:\data\emp_loader.ctl
SQLLDR scott/tiger@orcl control=d:\data\emp_loader.ctl skip=2 load=5

P267
10.4
d:\data\exp_scott.txt
BUFFER=999999
FILE=d:\data\dept_emp.dmp
COMPRESS=Y
CONSTRAINTS=Y
GRANTS=Y
INDEXES=Y
TABLES=(dept,emp)
ROWS=Y
EXP scott/tiger@orcl parfile=d:\data\exp_scott.txt
10.5
d:\data\exp_all.txt
BUFFER=999999
FILE=d:\data\all20090423.dmp
COMPRESS=Y
CONSTRAINTS=Y
GRANTS=Y
INDEXES=N
ROWS=N
FULL=Y
EXP system/systempwd@orcl parfile=d:\data\exp_all.txt

P268
10.7
d:\data\imp_scott.txt
BUFFER=999999
FILE=d:\data\dept_emp.dmp
GRANTS=Y
IGNORE=Y
FROMUSER=scott
TOUSER=hr
TABLES=(dept,emp)
IMP system/systempwd@orcl parfile=d:\data\imp_scott.txt

P271
10.8
CONN sys/syspwd@orcl AS SYSDBA
CREATE DIRECTORY dump_dir AS 'd:\data';
GRANT READ, WRITE ON DIRECTORY dump_dir TO scott;
EXPDP scott/tiger@orcl DIRECTORY=dump_dir DUMPFILE=scott.dmp
EXPDP system/systempwd@orcl DIRECTORY=dump_dir DUMPFILE=tablespace.dmp TABLESPACES=data_ts1,bigfile_ts1
10.9
d:\data\dept_emp.txt
DIRECTORY = dump_dir
DUMPFILE = dept_emp2.dmp
TABLES = (dept,emp)
EXPDP scott/tiger@orcl parfile=d:\data\dept_emp.txt

P273
10.10  
d:\data\imp_hr.txt
DIRECTORY = dump_dir
DUMPFILE = dept_emp2.dmp
REMAP_SCHEMA = scott:hr
TABLES = (dept,emp)
IMPDP system/systempwd@orcl parfile=d:\data\imp_hr.txt

P273
10.11
CONN scott/tiger@orcl
SET TIME ON
DELETE FROM emp;
COMMIT;
INSERT INTO emp
  SELECT * FROM emp AS OF TIMESTAMP 
    TO_TIMESTAMP('2009-04-24 10:40:25','YYYY-MM-DD HH24:MI:SS');
COMMIT;

P274
ذ汾ѯ
SET TIME ON
SELECT versions_starttime,versions_endtime,versions_xid,
       versions_operation
  FROM emp 
  VERSIONS BETWEEN TIMESTAMP minvalue AND maxvalue 
  ORDER BY versions_starttime;
SELECT versions_starttime,versions_endtime
  FROM emp
  VERSIONS BETWEEN TIMESTAMP 
   TO_DATE('2009-04-24 10:40:25','YYYY-MM-DD HH24:MI:SS')
   AND TO_DATE('2009-04-24 10:41:25','YYYY-MM-DD HH24:MI:SS');
10.12
CONN scott/tiger@orcl
DELETE FROM emp WHERE empno=7934;
COMMIT;
SELECT versions_starttime,versions_xid
  FROM emp 
  VERSIONS BETWEEN TIMESTAMP minvalue AND maxvalue
  ORDER BY versions_starttime;
CONN sys/syspwd@orcl AS SYSDBA
SELECT xid,undo_sql FROM flashback_transaction_query 
  WHERE xid='0A000A003D030000'; 
UPDATE emp SET sal=1000 WHERE empno=7900;
COMMIT;

P275
10.13
CONN sys/syspwd@orcl  AS SYSDBA
SHOW PARAMETER DB_RECOVERY_FILE_DEST
SHOW PARAMETER DB_FLASHBACK_RETENTION_TARGET
SELECT flashback_on FROM v$database;
SELECT DBID,NAME,LOG_MODE FROM V$DATABASE;
SHUTDOWN IMMEDIATE
STARTUP MOUNT
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE FLASHBACK ON;
ALTER DATABASE OPEN;
CONN scott/tiger@orcl
DELETE FROM emp;
COMMIT;
CONN / AS SYSDBA
SHUTDOWN IMMEDIATE
STARTUP MOUNT EXCLUSIVE
FLASHBACK DATABASE TO TIMESTAMP(TO_DATE('2009-04-25 13:09:00','YYYY-MM-DD HH24:MI:SS'));
ALTER DATABASE FLASHBACK OFF;
ALTER DATABASE NOARCHIVELOG;
ALTER DATABASE OPEN RESETLOGS;
CONN scott/tiger
SELECT * FROM emp;

P276

CONN scott/tiger@orcl
ALTER TABLE emp ENABLE ROW MOVEMENT;
FLASHBACK TABLE emp TO TIMESTAMP
  TO_TIMESTAMP('2009-04-25 14:20:08','YYYY-MM-DD HH24:MI:SS');
SELECT * FROM emp;

P277
drop table bonus;
FLASHBACK TABLE bonus TO BEFORE DROP;
SELECT object_name,original_name,droptime,dropscn FROM RECYCLEBIN;
PURGE RECYCLEBIN;




