把同一数据库的第1张表中的数据快速导入到其它表中,有时也需要有条件的导入部分数据。
方法二(推荐方法)
insert /*+ APPEND */ into bosscustinfo nologging (msisdn,imsi,password,question,answer,paytype)
select msisdn,imsi,password,question,answer,paytype from basetab
where 。。。。
该方法也适合于把一个平常表的数据导入到分区表中。注意一定要用APPEND的hint,这样的速度会快得多,
也不会产生大量的日志以至把undo tablespace写满。
方法三(推荐方法)
Create table bosscustinfo(msisdn,imsi,password,question,answer,paytype) nologging
As
select msisdn,imsi,password,question,answer,paytype from basetab
where 。。。
如何在数据库内部视图查处实例名
SQL> select inst_id,instance_name,status,version from gv$instance;
如何查看数据库中被锁定的对象
SQL> SELECT SID FROM V$MYSTAT WHERE ROWNUM=1;
SID
----------
153
Elapsed: 00:00:00.01
SQL> select sid,substr(owner,1,5),substr(OBJECT,1,10),substr(type,1,10) from v$access where sid=153;
SID SUBST SUBSTR(OBJ SUBSTR(TYP
---------- ----- ---------- ----------
153 SYS GV$ACCESS VIEW
153 SYS V$ACCESS VIEW
153 SYS X$KGLDP TABLE
153 SYS X$KGLLK TABLE
153 SYS X$KGLOB TABLE
153 SYS X$KSUSE TABLE
6 rows selected.
Elapsed: 00:00:00.04
SQL> SELECT A.OWNER,
2 A.OBJECT_NAME,
3 B.XIDUSN,
4 B.XIDSLOT,
5 B.XIDSQN,
6 B.SESSION_ID,
7 B.ORACLE_USERNAME,
8 B.OS_USER_NAME,
9 B.PROCESS,
10 B.LOCKED_MODE,
11 C.MACHINE,
12 C.STATUS,
13 C.SERVER,
14 C.SID,
15 C.SERIAL#,
16 C.PROGRAM
17 FROM ALL_OBJECTS A,
18 V$LOCKED_OBJECT B,
19 V$SESSION C
20 WHERE ( A.OBJECT_ID = B.OBJECT_ID )
21 AND (B.PROCESS = C.PROCESS )
22 ORDER BY 1,2;