该为修改对象（这里为表）的创建时间试验过程，可能由于某种原因需要对对象的创建时间进行修改:)

窗口一：

以feiyi帐号登陆，这里准备修改表test的创建时间，目前为：2007-07-10 21:26:33，准备修改为：2007-01-01 00:00:00：

21:37:39 SQL> show user
USER 为"FEIYI"
21:37:38 SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';

会话已更改。
21:37:41 SQL> select sysdate from dual;

SYSDATE
-------------------
2007-07-19 21:37:48

21:38:05 SQL> select table_name from user_tables;

TABLE_NAME
------------------------------
LIST_CUSTOMERS
TEST

21:38:11 SQL> select object_id,object_name,created,status from user_objects;

OBJECT_ID OBJECT_NAME CREATED STATUS
---------- ----------------------------- -------------------------- ------------
30320 LIST_CUSTOMERS 2007-07-11 16:34:29 VALID
30323 LIST_CUSTOMERS 2007-07-11 16:34:29 VALID
30321 LIST_CUSTOMERS 2007-07-11 16:34:29 VALID
30324 LIST_CUSTOMERS 2007-07-11 16:34:29 VALID
30322 LIST_CUSTOMERS 2007-07-11 16:34:29 VALID
30319 LIST_CUSTOMERS 2007-07-11 16:34:29 VALID
30307 TEST 2007-07-10 21:26:33 VALID
30349 TR_LOGIN 2007-07-13 00:35:23 INVALID
30348 TR_LOGIN_FILTRATE 2007-07-12 23:56:46 INVALID

已选择9行。

21:38:21 SQL>

窗口二：

以sys超级用户进行修改

SQL> show user
USER 为"SYS"
SQL> set time on
21:37:13 SQL> select sysdate from dual;

SYSDATE
-------------------
2007-07-19 21:37:27
21:38:59 SQL> select obj#,name,namespace,ctime,mtime,stime,status from obj$ where obj#=30307;

OBJ# NAME NAMESPACE CTIME MTIME STIME STATUS
---------- --------- ---------- ------------------- ------------------- ------------------- ----------
30307 TEST 1 2007-07-10 21:26:33 2007-07-10 21:26:33 2007-07-10 21:26:33 1

21:39:10 SQL>

21:39:10 SQL> update obj$ set ctime=to_date('2007-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss') where name='TEST' and obj#=30307;

已更新 1 行。

21:41:49 SQL> commit;

提交完成。

21:42:44 SQL> select obj#,name,namespace,ctime,mtime,stime,status from obj$ where obj#=30307;

OBJ# NAME NAMESPACE CTIME MTIME STIME STATUS
-------- ------------ ------------------ ------------------- ------------------- ------------------- ----------
30307 TEST 1 2007-01-01 00:00:00 2007-07-10 21:26:33 2007-07-10 21:26:33 1

21:42:47 SQL>

窗口一：

查询结果生效

feiyi:

21:44:42 SQL> select object_id,object_name,created,status from user_objects;

OBJECT_ID OBJECT_NAME CREATED STATUS
---------- --------------------------- ------------------------- ----------------
30320 LIST_CUSTOMERS 2007-07-11 16:34:29 VALID
30323 LIST_CUSTOMERS 2007-07-11 16:34:29 VALID
30321 LIST_CUSTOMERS 2007-07-11 16:34:29 VALID
30324 LIST_CUSTOMERS 2007-07-11 16:34:29 VALID
30322 LIST_CUSTOMERS 2007-07-11 16:34:29 VALID
30319 LIST_CUSTOMERS 2007-07-11 16:34:29 VALID
30307 TEST 2007-01-01 00:00:00 VALID
30349 TR_LOGIN 2007-07-13 00:35:23 INVALID
30348 TR_LOGIN_FILTRATE 2007-07-12 23:56:46 INVALID

已选择9行。