RE: Duhvelopers

Pat,
I think you will find that most of the DBA's here will agree with you on the need for recognizing the competent developers.

Competent developers are NOT DUHvelopers. DUHvelopers are those types that, like the subject of the lead of this thread, just don't get it. Putting all the tables and indexes for an application in the same tablespace AND having that tablespace be SYSTEM is a DUHveloper act not a developer act. This is type of bozo stunt is worthy of the derision that this thread has generated. If you are offended by the term DUHveloper, take a deep breath, step back, and visualize this guy as a consultant on your development team or worse your supervisor. It will help you put into perspective that we don't encompass all developers with this term... only those that deserve it. Feel free to use it yourself when it applies. Sooner or later you will have the misfortune of having to work with one and understanding will be clear. ;-0

Rodd Holman

On Tue, 2003-04-15 at 11:28, Gorden-Ozgul, Patricia E wrote:
> Hi all,
>
> Just a brief note to remind the DBAS that there would be no database to be
> administered without an application which requires developers!
>
> Cordially with regards,
> Pat Gorden-Ozgul
>
> -----Original Message-----
> Sent: Tuesday, April 15, 2003 11:29 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Cool. Good idea. Thanks for the tip.
>
> --Walt
>
> P.S. I'd mention using Perl, but that would obviously be a blatant attempt
> to suck up to the list's Fearless Leader. :>)
>
> > -----Original Message-----
> > From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM]
> > Sent: Tuesday, April 15, 2003 9:09 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Duhvelopers
> >
> >
> > Walt
> > What I do (on Unix) is
> >
> > strings export.dmp | fold > table.sql
> >
> > and then edit the resulting file by removing everything
> > except the CREATE
> > TABLE portion and rejoining the words that got split over the
> > end of line.
> >
> > Dennis Williams
> > DBA, 40%OCP, 100% DBA
> > Lifetouch, Inc.
> > dwilliams_at_lifetouch.com
> >
> >
> > -----Original Message-----
> > Sent: Tuesday, April 15, 2003 9:04 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Sure you can. I do it on a regular basis here, as we have
> > several tables
> > containing LOB's.
> >
> > I've also been known to edit the import file itself and change the
> > tablespace definition, but not officially, since that is
> > supposed to be an
> > absolute no-no.
> >
> > --Walt Weaver
> > Bozeman, Montana
> >
> > > -----Original Message-----
> > > From: Rachel Carmichael [mailto:wisernet100_at_yahoo.com]
> > > Sent: Tuesday, April 15, 2003 4:59 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: Duhvelopers
> > >
> > >
> > > I haven't had the joy(?) of working with LOBs so this
> > question may be
> > > totally off-base but can't you create the empty table, including the
> > > LOB segment tablespace definition, where you want it and
> > THEN import?
> > >
> > >
> > > --- "Deshpande, Kirti" <kirti.deshpande_at_verizon.com> wrote:
> > > > Melissa,
> > > >
> > > > Not a bug. It is how it works, unfortunately.
> > > >
> > > > According the Utilities Guide:
> > > > " By default, a table is imported into its original tablespace.
> > > > If the tablespace no longer exists, or the user does not have
> > > > sufficient quota in the tablespace, the system uses the default
> > > > tablespace for that user, unless the table:
> > > > Is partitioned
> > > > Is a type table
> > > > Contains LOB, VARRAY or OPAQUE type columns
> > > > Has an index-organized table (IOT) overflow segment. "
> > > >
> > > > So, you are stuck with these LOBs, unless you can get a new export
> > > > file after they correct the source. But for now you may
> > have to let
> > > > the import dump these tables (with LOBs) into the original
> > > tablespace
> > > > and then move them out later..
> > > >
> > > > I had to deal with a similar case just last week.... with a Vendor
> > > > supplied dump file containing tables with LOBs. I ended
> > up creating
> > > > the tablespaces they wanted...
> > > >
> > > > HTH,
> > > >
> > > > - Kirti
> > > >
> > > > -----Original Message-----
> > > > Sent: Monday, April 14, 2003 10:04 PM
> > > > To: Multiple recipients of list ORACLE-L
> > > >
> > > >
> > > >
> > > > The tables that didn't create all contain LOB's. The
> > tables without
> > > > LOBs created with no problems.
> > > >
> > > > CREATE TABLE ...........
> > > > TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CHUNK 4096 P"
> > > > "CTVERSION 10 NOCACHE STORAGE(INITIAL 12288 NEXT 12288
> > > MINEXTENTS 1
> > > > MAXEXTE"
> > > > "NTS 249 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL
> > > > DEFAULT))"
> > > > IMP-00003: ORACLE error 1950 encountered
> > > > ORA-01950: no privileges on tablespace 'SYSTEM'
> > > > IMP-00017: following statement failed with ORACLE error 1950:
> > > >
> > > > Some bug probably.
> > > >
> > > > -----Original Message-----
> > > > Sent: Monday, April 14, 2003 9:52 PM
> > > > To: 'ORACLE-L_at_fatcity.com'
> > > >
> > > >
> > > > List,
> > > >
> > > > It's late, and I'm scratching my head on this.
> > > >
> > > > Oracle 9IR2 Sun Solaris
> > > >
> > > > I've got a dump file from some consultant DUHvelopers. All the
> > > > tables were created in the system tablespace along with indexes
> > > > etc....
> > > >
> > > > In the past, I've been able to just import into another
> > users schema
> > > > and the tables are created in the default tablespace. For some
> > > > reason this export file is still looking for the system tablespace
> > > > when trying to create the tables.
> > > >
> > > > What am I missing here?
> > > >
> > > > TIA
> > > >
> > > >
> > > >
> > >
> > >
> > > __________________________________________________
> > > Do you Yahoo!?
> > > The New Yahoo! Search - Faster. Easier. Bingo
> > > http://search.yahoo.com
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Rachel Carmichael
> > > INET: wisernet100_at_yahoo.com
> > >
> > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > > San Diego, California -- Mailing list and web
> > hosting services
> > >
> > ---------------------------------------------------------------------
> > > 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.net
> > --
> > Author: Weaver, Walt
> > INET: wweaver_at_rightnow.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > 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.net
> > --
> > Author: DENNIS WILLIAMS
> > INET: DWILLIAMS_at_LIFETOUCH.COM
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > 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.net
> --
> Author: Weaver, Walt
> INET: wweaver_at_rightnow.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net

-- 
Rodd Holman <roddholman_at_hotpop.com>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rodd Holman
  INET: roddholman_at_hotpop.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).