Hi,
One of the reason I'm saying that is that I just tuned
a batch job where in a huge loop there was a create
and a drop table . Performance was awful.
I'm more a development dba than a production dba so
I'm usually aware of all objects in the database.
The main thing is that "usually" the dba has a more
global vision of the application/project/database,
that's why he can make informed decision.
By nature , developpers are "usually" more focused on
a part of the system and are more concerned by their
part than the overall health of the system.
HTH
- Gabriel Galanternik <ggalanterni_at_tesis-oys.com.ar>
a écrit : > 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
>
>
=== message truncated ===
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).
Received on Thu Feb 01 2001 - 05:15:58 CST
