摘要:
oracle 11 g标准版正确闪回执行方式:SQL> shutdown; SQL> startup mount; 数据库启动到mount下 SQL> alter table SY_GLOBAL_NAME enable row movement;--意思是允许Oracle修改rowid。Oracle插入数据时会为该条数据分配唯一rowid并且不变,要启用闪回功能必须开启可修改rowid功能 SQL> SQL> flashback table SY_GLOBAL_NAME TO TIMESTAMP TO_TIMESTAMP('2013-05-04 03:16 阅读全文
摘要:
1 查看指定用户SQL> show user;USER is "CICI"2 查看表空间使用情况select distinct (default_tablespace) ,temporary_tablespace from dba_users;3 字典表系列select * from v$option;select * from v$version; 阅读全文
摘要:
sql格式或者语法错误例如将‘ 改为' 阅读全文
摘要:
当遇到如上错误时候执行如下语句SQL> exitDisconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production[root@localhost Desktop]# sqlplus "sys/cici123love as sysdba"SQL*Plus: Release 10.2.0.1.0 - Production on Sat Feb 16 11:38:47 2013Copyright (c) 1982, 2005, Oracle. All rights res 阅读全文