Saul,
Sorry, I wasn't clear enough. I was referring to the
bug that could potentially corrupt the database (the
one Kevin mentioned), not the bug generating the
ORA-600 error that you mentioned.
- Anita
- "Solomon, Saul M." <ssolomon_at_ppg.com> wrote:
> No, this bug is one where the export hangs forever
> as per Kumanan's description. It's fixed by patching
> 8.1.7 or by putting
>
> event = "10297 trace name context forever, level 1"
>
> in the init.ora. I think the note is 144794.1 on
> Metalink.
>
> Saul Solomon
> Senior Database Administrator
> PPG Industries
> ssolomon_at_ppg.com
> 412 434-3504
>
>
>
> -----Original Message-----
> Sent: Thursday, June 21, 2001 11:33 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Kevin,
>
> I believe the bug to which he was referring is bug
> 970640 documented in Note: 76670.1 "ALERT:
> Transportable Tablespaces can Corrupt Target
> Database"
>
> This bug is specific to 8.1.5 and is fixed in 8.1.6+
>
> The bug is in the way export creates the dmp file of
> the transportable tablespace metadata and does not
> always happen. If you attempt to import an 8.1.5
> export file that would cause the corruption into an
> 8.1.6+ db it will fail with ORA-29336 "Internal
> error
> from DBMS_PLUGTS" thereby preventing the corruption.
>
> HTH,
>
> -- Anita
>
>
>
>
> --- Kevin Lange <kgel_at_ppoone.com> wrote:
> > There is definitely a bug. At an IOUGA conference
> a
> > while back I sat thru a
> > session where he was talking about all the things
> to
> > do with Transportable
> > Tablespaces ..... and at the end of the talk he
> said
> > ........"But dont use
> > it unless you are up on the upcoming 8.1.7...
> there
> > is a bug that can
> > destroy your tablespace."
> >
> > So much for a well spent 30 minutes.
> >
> > -----Original Message-----
> > Sent: Wednesday, June 20, 2001 6:37 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Thanks.
> > I'll also try it with 816 and see if it works fine
> > there.
> >
> > Kumanan
> >
> > > -----Original Message-----
> > > From: Solomon, Saul M. [SMTP:ssolomon_at_ppg.com]
> > > Sent: 19 June 2001 21:41
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: Transportable tablespace problem in
> > 817
> > >
> > > This is a bug. You've probably got an ORA-600
> too
> > in your alert log. I had
> > > the same problem and upgraded to 8.1.7.1 to fix
> > it.
> > >
> > > Saul Solomon
> > > Senior Database Administrator
> > > PPG Industries
> > > ssolomon_at_ppg.com
> > > 412 434-3504
> > >
> > >
> > >
> > > -----Original Message-----
> > > Sent: Tuesday, June 19, 2001 4:22 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > I'm trying to a transportable but the export
> > session is hanging.
> > > The v$session says the session is actually
> active.
> > >
> > > Anybody here has any such experience?
> > >
> > > Any ideas to resolve this?
> > >
> > >
> > > Thanks
> > > Kumanan
> > >
> > > SQL> set autoprint on serveroutput on
> > > SQL> exec dbms_tts.transport_set_check
> > ('DATA',TRUE);
> > > PL/SQL procedure successfully completed.
> > > SQL> select * from sys.transport_set_violations;
> > > VIOLATIONS
> > >
> >
>
> > > --
> > > ----
> > > Index KBALASUN.PK_USERS_USERID in tablespace
> > INDEXTS enforces primary
> > > constriant
> > > s of table KBALASUN.USERS in tablespace DAT
> > > SQL> exec dbms_tts.transport_set_check
> > ('DATA,INDEXTS',TRUE);
> > > PL/SQL procedure successfully completed.
> > > SQL> select * from sys.transport_set_violations;
> > > no rows selected
> > >
> > > alter tablespace data read only;
> > > alter tablespace data read only;
> > >
> > > /tmp <ora> $ env
> > > NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
> > > ORACLE_SID=KBDB
> > >
> >
>
ORA_NLS33=/export/home/oracle/product/8.1.7/ocommon/nls/admin/data
> > > ORACLE_HOME=/export/home/oracle/product/8.1.7
> > >
> > >
> > > /tmp <ora> $ exp transport_tablespace=y
> > tablespaces=DATA,INDEXTS
> > > file=testtrans.dmp
> > >
> > > Export: Release 8.1.7.0.0 - Production on Tue
> Jun
> > 19 19:30:37 2001
> > >
> > > (c) Copyright 2000 Oracle Corporation. All
> rights
> > reserved.
> > >
> > >
> > > Username: sys as sysdba
> > > Password:
> > >
> > > Connected to: Oracle8i Enterprise Edition
> Release
> > 8.1.7.0.0 - Production
> > > JServer Release 8.1.7.0.0 - Production
> > > Export done in WE8ISO8859P1 character set and
> > WE8ISO8859P1 NCHAR character
> > > set
> > > Note: table data (rows) will not be exported
> > > About to export transportable tablespace
> > metadata...
> > > <its just hanging forever.>
> > >
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: abardeen1_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 Jun 21 2001 - 11:42:09 CDT