Adams, Matthew (GECP, MABG, 088130),
Hi, a simple test on 9202 tell me I do it:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.2.0 - Production
SQL> create user abcd identified by abcd;
User created.
SQL> grant dba to abcd;
Grant succeeded.
SQL> conn abcd/abcd
Connected.
SQL> desc sys.seg$
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE# NOT NULL NUMBER
BLOCK# NOT NULL NUMBER
TYPE# NOT NULL NUMBER
TS# NOT NULL NUMBER
BLOCKS NOT NULL NUMBER
EXTENTS NOT NULL NUMBER
INIEXTS NOT NULL NUMBER
MINEXTS NOT NULL NUMBER
MAXEXTS NOT NULL NUMBER
EXTSIZE NOT NULL NUMBER
EXTPCT NOT NULL NUMBER
USER# NOT NULL NUMBER
LISTS NUMBER
GROUPS NUMBER
BITMAPRANGES NOT NULL NUMBER
CACHEHINT NOT NULL NUMBER
SCANHINT NOT NULL NUMBER
HWMINCR NOT NULL NUMBER
SPARE1 NUMBER
SPARE2 NUMBER
Regards
zhu chao
msn:[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(China Oracle User Group)
======= 2003-03-05 11:49:00 ,you wrote��=======
>Previously, an account with the DBA role could
>directly query oracle's internal tables
>(user$, seg$, ts$, etc). Now in 9.2.0.2,
>it appears we can't. Does anybody know
>what version this changed in or where (or if)
>it was documented. A quick search on
>MetaLink came up empty.
>
>Matt
>
>----
>Matt Adams - GE Appliances - [EMAIL PROTECTED]
>We have enough youth.
>How about a fountain of intelligence?
= = = = = = = = = = = = = = = = = = = =
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: chao_ping
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
