Re: Dumb question

2002-02-03 Thread Deepak Thapliyal
hi sreeni, no diff between export imp uisng rac or normal non-rac configuration ... Deepak --- Shreeni <[EMAIL PROTECTED]> wrote: > Hi List, > > To ask a dumb question, is there any special way to > run exp/imp on > Oracle Parallel server on Solaris ?? Is parallel > server DBA different > tha

RE: Hot Backup to Tape

2002-02-03 Thread Deepak Thapliyal
whats imp is that you have the oracle binaries re-linked so that rman can communicate with the mml.. as for talking backups to tape use the "sbt_tape" in the allocate channel and u should fine Deepak --- Sinard Xing <[EMAIL PROTECTED]> wrote: > What tape DDS3 or DLT > -Original Message

Re: Backup and Recovery

2002-02-03 Thread Deepak Thapliyal
nope .. this should just work fine:) --- Randy Kirkpatrick <[EMAIL PROTECTED]> wrote: > Listmembers, > > Are there any "gotchas" with restoring just one > datafile from a hot backup > and applying the archive logs? Will applying the > archive logs only affect > the restored datafile? For instance

RE: EXP flashing a couple of errors?

2002-02-03 Thread Abdul Aleem
Thank you, Barb. It worked fine. Aleem -Original Message- Sent: Friday, February 01, 2002 10:05 PM To: Multiple recipients of list ORACLE-L Subject:RE: EXP flashing a couple of errors? Aleem: You need to run ORACLE_HOME/rdbms/admin/catqueue against your database as user

Backup and Recovery

2002-02-03 Thread Randy Kirkpatrick
Listmembers,   Are there any "gotchas" with restoring just one datafile from a hot backup and applying the archive logs? Will applying the archive logs only affect the restored datafile? For instance, if I have a hot backup from Monday and all the archive logs to the current date and a disk

RE: Hot Backup to Tape

2002-02-03 Thread Sinard Xing
What tape DDS3 or DLT -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Quamrul PolashSent: 04 February 2002 00:30To: Multiple recipients of list ORACLE-LSubject: Hot Backup to Tape Hi, I need a script for on-line backup to tape. M

RE: formatting in SQLPLUS

2002-02-03 Thread Suhen Pather
Title: RE: formatting in SQLPLUS Thanks,   ššš I set pages 999 and it works fine now.   ššš Regards ššš $uhen   Or try. set pagesize xxx where xxx is the number of lines per page.   -Original Message- From: Dennis M. Heisler [mailto:[EMAIL PRO

Re: formatting in SQLPLUS

2002-02-03 Thread Dennis M. Heisler
Thanks, I realized that mistake after I sent it. I meant to type page and typed line instead. Craig Munday wrote: > > > Or try. > > set pagesize xxx > > where xxx is the number of lines per page. > > > -Original Message- > From: Dennis M. Heisler [mailto:[EMAIL PROTECTED]] > Sent: Mond

Re: formatting in SQLPLUS

2002-02-03 Thread Dennis M. Heisler
Oops... that's pagesize, not linesize "Dennis M. Heisler" wrote: > set linesize = xxx > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Dennis M. Heisler > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Dieg

RE: formatting in SQLPLUS

2002-02-03 Thread Craig Munday
Title: RE: formatting in SQLPLUS Or try. set pagesize xxx where xxx is the number of lines per page. -Original Message- From: Dennis M. Heisler [mailto:[EMAIL PROTECTED]] Sent: Monday, 4 February 2002 12:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: formatting in

Re: formatting in SQLPLUS

2002-02-03 Thread Dennis M. Heisler
set linesize = xxx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis M. Heisler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---

Dumb question

2002-02-03 Thread Shreeni
Title: Message Hi List,   To ask a dumb question, is there any special way to run exp/imp on Oracle Parallel server on Solaris ?? Is parallel server DBA different than a "regular" DBA ?? :)   TIA   Shreeni Shreenivasa Raoe-Zing Technologies, Inc..41-43 Beekman Street, 3rd FloorNew York, NY

formatting in SQLPLUS

2002-02-03 Thread Suhen Pather
List,   I am creating a report via sqlplus.   I am working with the formatting.  When I run the report it puts the headings for the columns after every 2 rows of the report.  I would like to have the headings at the top of the report only.   I could set the heading off but it would

Temporal or Time-Oriented Databases (was auditing tables)

2002-02-03 Thread Craig Munday
Title: Temporal or Time-Oriented Databases (was auditing tables) The thread on auditing tables and the mention of temporal or time-oriented databases prompted me to ask about a design problem that has recurred on different projects for me.  Seeing as this problem has occurred multiple times I

Hot Backup to Tape

2002-02-03 Thread Quamrul Polash
Hi, I need a script for on-line backup to tape. My server is Oracle 8.1.7 on Unix (AIX). Thanks for any tips,   /QuamrulGet your FREE download of MSN Explorer at http://explorer.msn.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quamrul Polash INET: [EMAIL PROT