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 #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
|
|
|
|
|
|