今天在对oracle的分区表进行测试练习时,出现了一个自我觉得与这方面毫无关系的错误。
在出现此错误后,我重新连接数据库,此错再没出现。请各位看看出现这种情况的原因到底
是在哪里?下面是我当时的代码,谢谢各位赐教。
------------------------------------
ORA-01012: not logged on
------------------------------------
SQL> select count(*) from a_partition partition(part2) ;
COUNT(*)
----------
1002
Elapsed: 00:00:00.01
SQL> select count(*)from a_partition ;
COUNT(*)
----------
3000
Elapsed: 00:00:00.00
SQL>
SQL>
SQL> select count(*) from a_partition partition (part1) ;
select count(*) from a_partition partition (part1)
*
ERROR at line 1:
ORA-01012: not logged on
Elapsed: 00:00:00.00
SQL> select count(*) from a_partition partition (part2) ;
select count(*) from a_partition partition (part2)
*
ERROR at line 1:
ORA-01012: not logged on
SQL>
SQL> conn /as sysdba
Connected.
SQL> select count(*) from a_partition partition (part1) ;
COUNT(*)
----------
1998
在出现此错误后,我重新连接数据库,此错再没出现。请各位看看出现这种情况的原因到底
是在哪里?下面是我当时的代码,谢谢各位赐教。
------------------------------------
ORA-01012: not logged on
------------------------------------
SQL> select count(*) from a_partition partition(part2) ;
COUNT(*)
----------
1002
Elapsed: 00:00:00.01
SQL> select count(*)from a_partition ;
COUNT(*)
----------
3000
Elapsed: 00:00:00.00
SQL>
SQL>
SQL> select count(*) from a_partition partition (part1) ;
select count(*) from a_partition partition (part1)
*
ERROR at line 1:
ORA-01012: not logged on
Elapsed: 00:00:00.00
SQL> select count(*) from a_partition partition (part2) ;
select count(*) from a_partition partition (part2)
*
ERROR at line 1:
ORA-01012: not logged on
SQL>
SQL> conn /as sysdba
Connected.
SQL> select count(*) from a_partition partition (part1) ;
COUNT(*)
----------
1998
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25380220/viewspace-688371/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25380220/viewspace-688371/