Home » Other » General » Location of Programs (Oracle 10g,10.2.0.3.0, Windows)
Location of Programs [message #457483] Mon, 24 May 2010 13:04 Go to next message
lakshmis
Messages: 101
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 #457485 is a reply to message #457483] Mon, 24 May 2010 13:14 Go to previous messageGo to next message
BlackSwan
Messages: 22790
Registered: January 2009
Senior Member
>I want to know where my Oracle Subprograms will be stored?
please clarify.

In what language are your "subprograms" written?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Location of Programs [message #457500 is a reply to message #457485] Mon, 24 May 2010 21:44 Go to previous messageGo to next message
ramoradba
Messages: 2452
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Please define "subprograms".

sriram Smile
Re: Location of Programs [message #457515 is a reply to message #457500] Tue, 25 May 2010 00:51 Go to previous messageGo to next message
Littlefoot
Messages: 19619
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 #457681 is a reply to message #457500] Tue, 25 May 2010 11:18 Go to previous messageGo to next message
lakshmis
Messages: 101
Registered: November 2008
Location: India
Senior Member
Hi,
Quote:

Please define "subprograms".

Hope this will help:
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/subprograms.htm#LNPLS008
Regards,
Lakshmi
Re: Location of Programs [message #457699 is a reply to message #457681] Tue, 25 May 2010 12:01 Go to previous message
Michel Cadot
Messages: 59142
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Migration Oracle9 to Oracle10
Next Topic: Document and Source management system
Goto Forum:
  


Current Time: Fri Sep 19 11:16:03 CDT 2014

Total time taken to generate the page: 0.14632 seconds