OraFAQ Forum: Training & Certification

Home » Other » Training & Certification » Where it stored

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Where it stored [message #265910]

Fri, 07 September 2007 17:02

devswami
Messages: 4
Registered: September 2007
Location: Schaumburg

Junior Member

Hi,everybody

I want to know when you create procedure,sequence,trigger,constraints then where acxtuly they stores means in which table in database.

Please give answer A.S.A.P.

Thanks in advance.

Regards

Dev

[Updated on: Fri, 07 September 2007 17:02]

Report message to a moderator

Re: Where it stored [message #265915 is a reply to message #265910]

Fri, 07 September 2007 17:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Please give answer A.S.A.P.

You can have your answer good, fast, or cheap.
Pick any 2 from above list.

Report message to a moderator

Re: Where it stored [message #265944 is a reply to message #265910]

Sat, 08 September 2007 01:00

Michel Cadot
Messages: 68644
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

DICT contains the list of dictionary views:

SQL> desc dict
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 TABLE_NAME                                VARCHAR2(30)
 COMMENTS                                  VARCHAR2(4000)

DBA_VIEWS contains the TEXT of the views:

SQL> desc dba_views
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 OWNER                            NOT NULL VARCHAR2(30)
 VIEW_NAME                        NOT NULL VARCHAR2(30)
 TEXT_LENGTH                               NUMBER
 TEXT                                      LONG
 TYPE_TEXT_LENGTH                          NUMBER
 TYPE_TEXT                                 VARCHAR2(4000)
 OID_TEXT_LENGTH                           NUMBER
 OID_TEXT                                  VARCHAR2(4000)
 VIEW_TYPE_OWNER                           VARCHAR2(30)
 VIEW_TYPE                                 VARCHAR2(30)
 SUPERVIEW_NAME                            VARCHAR2(30)

Now you have all the elements necessary to answer your question.

You can also read:
Oracle� Database Reference
Part II Static Data Dictionary Views

Regards
Michel

Report message to a moderator

Re: Where it stored [message #266096 is a reply to message #265910]

Sun, 09 September 2007 12:46

marcosbr
Messages: 24
Registered: April 2007
Location: Argentina

Junior Member

I had the same question when I stared with Oracle9i, but the concepts are the same now for oracle9i or oracle10g.

You have to learn about schema and schema object concepts, please review you administrator guide.

So, if you have login with Sys user and you have created a table “MyNewTable”, you have to go to the administration console and enter in Sys schema in table, and you will find it.

Otherwise, if you have created a table when you were login with SH user, you have to find your table using the administration console inside the SH schema, in tables.

I guess it explain your doubt, let me know.

Cheers

Marcos

Report message to a moderator

Re: Where it stored [message #266097 is a reply to message #265910]

Sun, 09 September 2007 13:00

marcosbr
Messages: 24
Registered: April 2007
Location: Argentina

Junior Member

me again..,
i guess my response was wrong.., follow the Michel's answer.

Marcos

Report message to a moderator

Re: Where it stored [message #266123 is a reply to message #265910]

Sun, 09 September 2007 22:19

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

About Constratints,
dba_constraints.
About procedure,
dba_procedures
About triggers,
dba_triggers

Suppose You can get trigger_body by ,

SQL> select trigger_body from dba_triggers where rownum=1;

TRIGGER_BODY
---------------------------------------------------------

-----------------------
DECLARE
  prop_count  NUMBER;
BEGIN
  SELECT count(*) into prop_count
    FROM s

Report message to a moderator

Re: Where it stored [message #266422 is a reply to message #265910]

Mon, 10 September 2007 18:46

devswami
Messages: 4
Registered: September 2007
Location: Schaumburg

Junior Member

Hi,Everyone

Thank you very much for your response.

Take Care.

Bye....

regards
Dev

[Updated on: Mon, 10 September 2007 18:47]

Report message to a moderator

Previous Topic:	147 Study Material
Next Topic:	Doubts in trigger (merged by LF and MC)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 02:21:28 CDT 2024