8i

ANyone have any info on 8i features
-----Original Message-----
From: Andreas Jung [mailto:ajung_at_sz-sb.de] Sent: 31 May 2000 08:16
To: Multiple recipients of list ORACLE-L Subject: Re: clobs

On Tue, May 30, 2000 at 11:07:09AM -0800, Jaime Perez wrote:
> Morning everyone,
>
> Can someone show me or guide me on how I can
> display full information from a clob field?

With with application ? sqlplus ?

Andreas

-- 
Author: Andreas Jung
  INET: ajung_at_sz-sb.de

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).




------------------------------

 From: George.Brennan_at_warnermusic.com
 Date: Wed, 31 May 2000 8:47:23 GMT
 Subject: RE: Newbie DBA

Measure twice and cut once.

George



> -----Original Message-----

> From: "Janusz, Kenneth" <Kenneth.Janusz_at_fingerhut.com>

> [mailto:Kenneth.Janusz_at_fingerhut.com]

> Sent: Tuesday, May 30, 2000 10:10 PM

> To: smtp_at_inl001@servers["Multiple recipients of list ORACLE-L"

> <ORACLE-L_at_fatcity.com>]

> Subject: Newbie DBA

> 

> 

> Hi All:

> 

> In a couple of weeks I will be joining another company as an 

> Oracle DBA.

> This will be the first time for me as a DBA.  Although I a 

> have a good idea

> of what the job entails, I could use some helpful hints from 

> some of you

> folks that have spent time in the trenches.

> 

> TIA,

> 

> Ken

> 

> __________________________________________________________________

> Kenneth C. Janusz, CPIM		FINGERHUT DTC

> Senior Technical Analyst	            	6150 Trenton Lane North,

> DC4N

> 					            Plymouth, Minnesota

> 55442

>  *Voice:  763.519.4403		

>  *Email: kenneth.janusz_at_fingerhut.com

> 

>                   |\      _,,,---,,_         

>             ZZZzz /,`.-'`'    -.  ;-;;,_ 

> _________________|,4-  ) )-,_. ,\ (____-'_________________________

>                 '---''(_/--'  `-'\_)	

> 

> "Dogs come when they're called; cats take a message and get 

> back to you

> later." -- Mary Bly	

> __________________________________________________________________

> 

> 

> 

> -- 

> Author: Janusz, Kenneth

>   INET: Kenneth.Janusz_at_fingerhut.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).

> 

> 





------------------------------

 From: George.Brennan_at_warnermusic.com
 Date: Wed, 31 May 2000 9:01:19 GMT
 Subject: RE: help with query :)

That will only retrieve the first 10 rows not the last 10 entered. That needs an identifying column, such as a sequence based trigger or auditing.

George,



> -----Original Message-----

> From: "Abdul Aleem" <abchaudhary-ho_at_beaconhouse.edu.pk>

> [mailto:abchaudhary-ho_at_beaconhouse.edu.pk]

> Sent: Wednesday, May 31, 2000 8:59 AM

> To: smtp_at_inl001@servers["Multiple recipients of list ORACLE-L"

> <ORACLE-L_at_fatcity.com>]

> Subject: RE: help with query :)

> 

> 

> In your WHERE clause try adding ROWCOUNT < 10;

> 

> Regards,

> 

> Aleem

> 

> 		-----Original Message-----

> 		From:	Yohans Mendoza

> [mailto:yohans_at_demiurge.sirius-images.net]

> <mailto:[mailto:yohans_at_demiurge.sirius-images.net]> 

> 		Sent:	31 May, 2000 5:25 AM

> 		To:	Multiple recipients of list ORACLE-L

> 		Subject:	help with query :)

> 

> 		hi all,

> 

> 		hope you're ok

> 		I have this "silly" question. Is there an easy way to

> retrieve the last 10

> 		records that have been entered in a given table?

> 

> 		TIA

> 

> 		--Yohans

> 

> -- 

> Author: Abdul Aleem

>   INET: abchaudhary-ho_at_beaconhouse.edu.pk

> 

> 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).

> 

> 







------------------------------

 From: Sajid Iqbal <sajid_at_u-net.net>
 Date: Wed, 31 May 2000 10:13:09 +0100 (BST)
 Subject: RE: Database Cloning 

On Tue, 30 May 2000, Miguel Urosa wrote:



> 	And what about your $TNSADMIN variable value to indicate path of

> TNSNAMES.ORA?.




The same thing still happens !?




> 

> 	HTH

> 

> > -----Mensaje original-----

> > De:	Sajid Iqbal [SMTP:sajid_at_u-net.net]

> > Enviado el:	martes 30 de mayo de 2000 16:10

> > Para:	Multiple recipients of list ORACLE-L

> > Asunto:	RE: Database Cloning 

> > 

> > 

> > Yes the SID name is the same as the production so I've changed the machine

> > server name !

> > 

> > --

> > U-NET Ltd  a VIA NET.WORKS Inc company

> > Sajid Iqbal                    | Mail : sajid_at_u-net.net

> > Database DBA/Developer         | Ext  : 4485

> > U-NET Ltd                      | ICQ  : 43903417

> > Warrington, Cheshire, UK       |  

> > 

> > 

> > On Tue, 30 May 2000, Deshpande, Kirti wrote:

> > 

> > > Have you modified your TNSNAMES.ora on the PC to point to correct SID

> > name

> > > on a correct Server? Also, have you made modified your LISTENER.ORA file

> > on

> > > the Server to begin listening for the test SID name? 

> > >  

> > > - Kirti 

> > > 

> > > > -----Original Message-----

> > > > From:	Sajid Iqbal [SMTP:sajid_at_u-net.net]

> > > > Sent:	Tuesday, May 30, 2000 7:11 AM

> > > > To:	ORACLE-L_at_fatcity.com; oracle_at_telelists.com;

> > oracledba_at_lazydba.com

> > > > Subject:	Database Cloning 

> > > > 

> > > > Hi 

> > > > 

> > > > I have just cloned our production DB to a test machine (ie copy all

> > > > datafiles, init files, netwrok files etc) after doing recovery on the

> > DB

> > > > I can connect through server manager and see all the data..

> > > > 

> > > > However I can't connect via sqlplus (from a pc) using sqlnet.. it

> > keeps

> > > > telling me that Oracle is not available.. when the database is started

> > and

> > > > the tnslistener is also started.

> > > > 

> > > > TIA

> > > > 

> > > > Saj Iqbal

> > > >  --

> > > > U-NET Ltd  a VIA NET.WORKS Inc company

> > > > Sajid Iqbal                    | Mail : sajid_at_u-net.net

> > > > Database DBA/Developer         | Ext  : 4485

> > > > U-NET Ltd                      | ICQ  : 43903417

> > > > Warrington, Cheshire, UK       |  

> > > > 

> > > > 

> > > > 

> > > > --------

> > > > If you're bored, then visit the list's website: http://www.lazydba.com

> > > > (updated daily)

> > > > to unsubscribe, send a blank email to

> > oracledba-unsubscribe_at_quickdoc.co.uk

> > > > to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk

> > > 

> > 

> > -- 

> > Author: Sajid Iqbal

> >   INET: sajid_at_u-net.net

> > 

> > 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).

> -- 

> Author: Miguel Urosa

>   INET: murosa_at_smseuropa.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).

> 




------------------------------

 From: ddorr.cs_at_clearstream.com
 Date: Wed, 31 May 2000 11:13:00 +0200
 Subject: RE: Point in time recovery

Thanks to all for your responses.
I've also found a note ( Note:29430.1 ) on Metalink about : ' How to recover
a database having added a datafile since the last backup ' which says that
one have to create the datafile and resume the recovery.
So this seems to be the 'normal' behaviour of the Oracle recovery process.



> ----------

> From: 	A. Bardeen[SMTP:abardeen1_at_yahoo.com]

> Reply To: 	ORACLE-L_at_fatcity.com

> Sent: 	Wednesday, May 31, 2000 06:24

> To: 	Multiple recipients of list ORACLE-L

> Subject: 	Re: Point in time recovery

> 

> The correct command is:

> 

> ALTER DATABASE CREATE DATAFILE '<filename>';

> 

> This will create the file at the OS level, after which

> the recovery command can be executed again. 

> 

> Note:  This requires using a controlfile that contains

> the info from when these datafiles were created (i.e.

> the controlfile has to be from AFTER the datafiles

> were  added).  

> 

> HTH,

> 

> -- Anita

> --- Chris Royce <Chris_at_Royce.net> wrote:

> > 

> > 

> > Just a quick thought - this is also a problem with

> > 'standby databases' as the

> > ddl in the redos will not create the datafiles -

> > startup the database 'mount'

> > and try to do an 'alter system add datafile

> > '/dir/oradata/instance/file_name

> > etc' size 999M;' . I really do not know  (I haven't

> > had a chance to try it) if

> > this will work but is worth a try. Let me know ?? I

> > will probably test your

> > scenario tomorrow.

> > 

> > Good Luck

> > 

> > Chris Royce

> > 

> > 

> > 

> > ddorr.cs_at_clearstream.com wrote:

> > 

> > > I am trying to recover a database up to a certain

> > point in time.

> > > Restored my disks from a backup (disk to disk copy

> > with raw devices on

> > > disks), and the archived redo logs from tape,

> > > started a RECOVER database until time <timespec>

> > using backup controlfile;

> > > and finally got :

> > >

> > > ORA-00283: Recovery session canceled due to errors

> > > ORA-01244: unnamed datafile(s) added to

> > controlfile by media recovery

> > > ORA-01110: data file 66:

> > '/dev/rdsk/RTS_BS2/CRE_DATA01_03'

> > > ORA-01110: data file 65:

> > '/dev/rdsk/RTS_BS2/CRE_DATA01_02'