|
- [oracle@station90 ~]$ rman target / cmdfile=a.rcv
- Recovery Manager: Release 11.2.0.1.0 - Production on Mon Oct 16 19:18:50 2017
- Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367)
- RMAN> run {
- 2> set command id to 'botang';
- 3> allocate channel c1 device type sbt;
- 4> allocate channel c2 device type sbt;
- 5> backup tag 'MY4' duration 00:06 minimize load (datafile 1 channel c1 ) ( datafile 2,3,4,5 channel c2 ) ;
- 6> }
- 7>
- executing command: SET COMMAND ID
- using target database control file instead of recovery catalog
- allocated channel: c1
- channel c1: SID=73 device type=SBT_TAPE
- channel c1: Oracle Secure Backup
- allocated channel: c2
- channel c2: SID=195 device type=SBT_TAPE
- channel c2: Oracle Secure Backup
- Starting backup at 16-OCT-17
- channel c2: starting full datafile backup set
- channel c2: specifying datafile(s) in backup set
- input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
- input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
- input datafile file number=00005 name=+DATA/orcl/datafile/example.265.957437977
- input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
- channel c2: starting piece 1 at 16-OCT-17
- channel c1: starting full datafile backup set
- channel c1: specifying datafile(s) in backup set
- input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
- channel c1: starting piece 1 at 16-OCT-17
- channel c1: finished piece 1 at 16-OCT-17
- piece handle=26sh67l7_1_1 tag=MY4 comment=API Version 2.0,MMS Version 10.4.0.4
- channel c1: backup set complete, elapsed time: 00:05:55
- channel c1: throttle time: 0:05:23
- channel c2: finished piece 1 at 16-OCT-17
- piece handle=25sh67l7_1_1 tag=MY4 comment=API Version 2.0,MMS Version 10.4.0.4
- channel c2: backup set complete, elapsed time: 00:05:55
- channel c2: throttle time: 0:05:23
- Finished backup at 16-OCT-17
- Starting Control File and SPFILE Autobackup at 16-OCT-17
- piece handle=c-1343950367-20171016-00 comment=API Version 2.0,MMS Version 10.4.0.4
- Finished Control File and SPFILE Autobackup at 16-OCT-17
- released channel: c1
- released channel: c2
- Recovery Manager complete.
- [oracle@station90 ~]$
复制代码
- create table t05110_a ( a number default 99 );
- create table t05110_b ( a number ) ;
- select t.TABLE_NAME, t.DATA_DEFAULT
- from user_tab_columns t
- where t.TABLE_NAME like 'T05110_%';
-
- insert into t05110_a values (default );
-
- commit;
-
- select * from t05110_a;
-
- alter table t05110_a modify ( a default null ) ;
-
- select t.DATA_DEFAULT
- from user_tab_columns t
- where t.TABLE_NAME='T05110_A';
- insert into t05110_b values (default ) ;
- select * from t05110_b where a is null;
- insert into t05110_a values (default ) ;
- select * from t05110_a where a is null;
- ----
- create table t05110_c ( a varchar2(30) , b blob ) ;
- -----
- CREATE OR REPLACE PROCEDURE
- proc_blob ( p_1 varchar2, p_dir VARCHAR2, p_file VARCHAR2)
- IS
- v_f BFILE;
- v_b blob;
- BEGIN
- INSERT INTO t05110_c values(p_1, EMPTY_BLOB ()) RETURN b into v_b;
- v_f := BFILENAME (p_dir, p_file);
- DBMS_LOB.FILEOPEN (v_f, DBMS_LOB.FILE_READONLY);
- DBMS_LOB.LOADFROMFILE (v_b, v_f, DBMS_LOB.GETLENGTH (v_f));
- DBMS_LOB.FILECLOSE (v_f);
- commit;
- end;
-
-
- begin
- proc_blob ('JUPITER','PICDIR','jupiter.jpg');
- end;
-
-
- select * from t05110_c;
复制代码- select * from t05110_c ;
- select sysdate from dual;
- insert into t05110_d values (current_timestamp , 2 ) ;
- select * from t05110_d;
- create table t05110_e ( a timestamp(9) );
- insert into t05110_e values ( systimestamp);
- select * from t05110_e;
- create table t05110_f ( a timestamp with time zone ) ;
- insert into t05110_f values ( systimestamp);
- select * from t05110_f;
- create table t05110_g ( a timestamp with local time zone ) ;
- insert into t05110_g values ( systimestamp);
- select * from t05110_g;
复制代码
|
|