SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
Elapsed: 00:00:00.05
SQL> select count(*) from ip_info;
COUNT(*)
----------
33992732
Elapsed: 00:00:01.91
SQL> create table ip_info2 as (select * from ip_info);
Table created.
Elapsed: 00:02:21.57
前:
后：
阅读(918) | 评论(0) | 转发(0) |
