Gabriel, the dba needs to know about it, period, because he/she is responsible for storage and performance of the database overall. In addition he or she may have other ideas that you can use instead of actually creating a table (pl/sql tables or something?)
Repeat until you believe it: THE DBA IS YOUR FRIEND! THE DBA IS NOT MEAN!
HTH
Lisa
-----Original Message-----
From: Gabriel Galanternik [mailto:ggalanterni_at_tesis-oys.com.ar]
Sent: Wednesday, January 31, 2001 12:21 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: newbie: problem in dynamic SQL
stephane, just curious, really, no subtle lines...
should I, a developer, tell my dba that I'm gonna create temporary tables?
(I know most of you are dba's, please don't flame me...)
deep inside I would say, yes, but, really why?
Rigth access?
space allocation?
performance tunning?
curious dba?
FYI, I, as a technical support for my developers, I would think twice before
creating tables dinamically.
and I would ask very good reasons to do it.
But when I had to do it I really didn't realize to tell the dba...
Gabriel Galanternik
- Original Message -----
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, January 31, 2001 7:30 AM
On top of the explanation, I have 2 questions.
Are you a dba ?
If not, does your dba knows that you will create
dynamically ?
- Gabriel Galanternik <ggalanterni_at_tesis-oys.com.ar>
a écrit : > that's right and all code referencing this
table
> must be dynamic too
>
> my 0.02
> Gabriel Galanternik
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L
> Sent: Tuesday, January 30, 2001 7:35 AM
>
>
> Hi Anurag,
> Your table does not exist till the time the
> procedure is actually
> executed. So, when your procedure tries the access
> the table the compiler
> is going to complain cos it can't find the table you
> are referring to.
> Since at compile time your table does not exist.
> HTH
> Chandini
>
> -----Original Message-----
> dewan
> Sent: 30 January 2001 09:36
> To: Multiple recipients of list ORACLE-L
>
>
> hi,
> I am calling a stored procedure which dynamically
> creates a table in a procedure. But if I am
> accessing
> this table later in the procedure, ORACLE gives an
> error PLS-00201-saying that identifier must be
> declared(the identifier that it quotes is the name
> of
> the table which was created dynamcally).
> please guide me
> anurag
>
>
> Do You Yahoo!?
> Get your free @yahoo.co.uk address at
> http://mail.yahoo.co.uk
> or your free @yahoo.ie address at
> http://mail.yahoo.ie
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?anurag=20dewan?=
> INET: anu_dewan_at_yahoo.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (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).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Chandini Paterson
> INET: chandini.paterson_at_morse.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (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).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Gabriel Galanternik
> INET: ggalanterni_at_tesis-oys.com.ar
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (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).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
Get personalized email addresses from Yahoo! Mail - only $35
a year!
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
INET: stephane_paquette_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gabriel Galanternik
INET: ggalanterni_at_tesis-oys.com.ar
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).
Received on Wed Jan 31 2001 - 13:38:02 CST
