SQL*Plus: Release 10.1.0.0.0 - Beta on Thu Oct 16 20:35:19 2003 Copyright (c) 1982, 2003, Oracle Corporation. All rights reserved.
Connected to an idle instance. SQL> startup; ORACLE instance started. Total System Global Area 170990484 bytes Fixed Size 760724 bytes Variable Size 121634816 bytes Database Buffers 25165824 bytes Redo Buffers 23429120 bytes Database mounted. Database opened. SQL> desc view$; Name Null? Type ----------------------------------------- -------- ---------------------------- OBJ# NOT NULL NUMBER AUDIT$ NOT NULL VARCHAR2(38) COLS NOT NULL NUMBER INTCOLS NOT NULL NUMBER PROPERTY NOT NULL NUMBER FLAGS NOT NULL NUMBER TEXTLENGTH NUMBER TEXT LONG SQL> desc trigger$; Name Null? Type ----------------------------------------- -------- ---------------------------- OBJ# NOT NULL NUMBER TYPE# NOT NULL NUMBER UPDATE$ NOT NULL NUMBER INSERT$ NOT NULL NUMBER DELETE$ NOT NULL NUMBER BASEOBJECT NOT NULL NUMBER REFOLDNAME VARCHAR2(30) REFNEWNAME VARCHAR2(30) DEFINITION VARCHAR2(4000) WHENCLAUSE VARCHAR2(4000) ACTION# LONG ACTIONSIZE NUMBER ENABLED NUMBER PROPERTY NOT NULL NUMBER SYS_EVTS NUMBER NTTRIGCOL NUMBER NTTRIGATT NUMBER REFPRTNAME VARCHAR2(30) ACTIONLINENO NUMBER --- Mladen Gogala <[EMAIL PROTECTED]> wrote: > Much more menacing question: > Are the columns DBA_VIEWS.TEXT and DBA_TRIGGERS.TRIGGER_BODY still of > > the type long? > > ===== Have a nice day !! ------------------------------------------------------------ Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan 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).
