| Location of Programs [message #457483] |
Mon, 24 May 2010 13:04  |
lakshmis
Messages: 102
Registered: November 2008
Location: India
|
Senior Member |
|
|
Hi all,
I have installed ORACLE 10g in C:/.
I want to know where my Oracle Subprograms will be stored?
Regards,
Lakshmi.
|
|
|
|
|
|
|
|
| Re: Location of Programs [message #457515 is a reply to message #457500] |
Tue, 25 May 2010 00:51  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
From what I understood, your "subprograms" will be stored within the database. That's why they are called "stored procedures". When you create procedures or functions (packages, triggers), they are not in file system (i.e. you can't see them in Windows Explorer); CREATE PROCEDURE will create it, compile and save.
Here's something more about stored subprograms.
[Updated on: Tue, 25 May 2010 00:54] Report message to a moderator |
|
|
|
|
|
| Re: Location of Programs [message #457699 is a reply to message #457681] |
Tue, 25 May 2010 12:01 |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
So if you think about PL/SQL subprograms (thing we can't know as we are not mind readers and our crystal balls are broken) they reside in SYSTEM tablespace.
A very good reading: Database Concepts
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
