Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Duhvelopers

RE: Duhvelopers

From: Gorden-Ozgul, Patricia E <gorden_at_bnl.gov>
Date: Tue, 15 Apr 2003 08:28:25 -0800
Message-ID: <F001.00581765.20030415082825@fatcity.com>


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
-- 
Author: Gorden-Ozgul, Patricia E
  INET: gorden_at_bnl.gov

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).
Received on Tue Apr 15 2003 - 11:28:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US