Re: timing value in these stats

On Jun 17, 2001 at 07:40:25PM, Sairlao, Chark wrote: yeah, that is what I thought but can you tell me what is this? on sqlplus session with timing on 3981 rows selected. Elapsed: 00:04:245.23 SQL would it be hour:minute:milliSecond? It's a bug. Your time is 00:04:05.23, or something

Re: Backups on raw devices

On Jun 15, 2001 at 04:05:49PM, Christopher Spence wrote: In Oracle, you will get an inconsistent image of the data file, but that is true with any manual hot backup - cpio, tar, cp, etc. It is not a problem - iff the tablespace(s) are in backup mode. (Wasn't there something about

No Subject

LIST

Re: New certified DBA

RE: OT: Perl question

Hi Jared, Thank you for your advice. Without setting LD_LIBRARY_PATH before the installation I got the message ld.so.1: perl: fatal: libgdbm.so.2: open failed: No such file or directory during the Configure step. So I tried the installation again and this time not setting the

RE: Oracle 8i installation problem

Pankaj Just in case - you did reboot after changing /etc/system didn't you? Regards David Lord -Original Message- Sent: 18 June 2001 00:45 To: Multiple recipients of list ORACLE-L Hi Riyaj, It fails in the DB Assist step, I dont have to retry the entire installation from scratch. I

TNS-01201 Listener cannot find executable string for SID string

Hi I have problems configurating a listener on SUN-Solaris. My ORACLE_HOME is set to /opt/oracle/product/8.0.6 as environment variable. In my listener.ora file I have defined SID description ORACLE -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mikael Granhed INET:

TNS-01201 Listener cannot find executable string for SID string

Hi Sorry, I was to fast sending the first mail... I have problems configurating a listener on SUN-Solaris. My ORACLE_HOME is set to /opt/oracle/product/8.0.6 as environment variable. In my listener.ora file I have defined SID description Oracle Home Directory as /opt/oracle/product/8.0.6 Why is

RE: OT: Working from home

Didn't IBM have a standard, something like a good programmer will produce ten lines of code per day? That was in the days before OOP, though. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services|

Re: * I'm Looking for an Oracle Financials DBA for Miami,

I agree with Jared.. I think that OraStaff provides a valuable service to the DBA world and He does not clutter the bandwidth with a lot of junk. Good solid work opportunities in the DBA field. He does not email very often and his service is just that a service. In my mind a SPAM is for a

RE: OT: Working from home

Yeah, now it's one line per day. -Original Message- Sent: Monday, 18 June 2001 13:00 To: Multiple recipients of list ORACLE-L Didn't IBM have a standard, something like a good programmer will produce ten lines of code per day? That was in the days before OOP, though. Regards, Patrice

RE: OT: Working from home

They also used to rate their people by the number of KLOC's produced by their people in a rating period. KLOC's stands for (K) Thousand (L) Lines (O) of (C) code. [EMAIL PROTECTED] 06/18/01 09:10AM Yeah, now it's one line per day. -Original Message- Sent: Monday, 18 June 2001 13:00

Re: 9i On Linux

Hi, But Larry Ellison said that Oracle requires less hardware , network infrastructure and IT professionals. :-0 Regards, Antonio Belloni Joe Raube [EMAIL PROTECTED]@fatcity.com on 15/06/2001 18:02:27 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple

RE: 9i On Linux

Failed to install on rh7.1, PIII-450/256M (512M Swap). The installation consumed 460M Swap at max. Roger Liu -Original Message- Sent: Friday, June 15, 2001 4:21 PM To: Multiple recipients of list ORACLE-L Can any of you just confirm that Oracle 9i requires 500M of memory on Linux?

RE: Redo latch contention

Looks like your itrprof id doing the same thing as Millsap's www.hotsos.com (available already or soon)for which they are going to charge $50-100 per upload. Alex Hillman -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 16, 2001 12:26 PM To: Multiple recipients of list

OLE vs. ODBC

Does anyone know where I can find documented information on Oracle's current stance on ODBC vs. OLE? I am under the impression that they lean toward ODBC now. Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -- Please see the

Tablespace recovery - Point in time (TSPITR)

Title: Tablespace recovery - Point in time (TSPITR) Dear guru's Can any one please help me , how to do the tablespace point in time recovery. I reviewed the backup and recovery books, but still am not clear. I don't know how to make the 'Clone Database'. Hope that i can do TSPITR with

RE: Redo latch contention

Any description of x$trace? In the docs ?. Alex Hillman -Original Message- Sent: Saturday, June 16, 2001 5:35 PM To: Multiple recipients of list ORACLE-L Or with Cary Millsap's hprof/Sparky stuff (hotsos.com). I'm deligthed that guys like you and Cary are writing tools/products that

RE: 9i On Linux

Antonio; But 512 MB IS LESS ... -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, June 18, 2001 8:50 AM To: Multiple recipients of list ORACLE-L Hi, But Larry Ellison said that Oracle requires less hardware , network infrastructure and IT professionals. :-0

RE: Oracle 8i installation problem

David, As I had mentioned, the dbassist utility fails in the 3rd step at 82%. At this point, it gives the error Oracle not Available and the only option that I had was to Ignore Abort. I clicked on Ignore for a longtime. Later I found from the web that the semmsl semmns values were too

Multiple databases under the same ORACLE_HOME

Title: Multiple databases under the same ORACLE_HOME Dear list ! Is it possible to create multiple databases/instances under the same ORACLE_HOME on NT ? If yes , what should be done (create services etc..) ? Thanks a lot in advance for your answer.

RE: the conversion is from Mainframe flat file to Unix Flat file

EBCDIC is the character set used on main frames. Many products that move them to other systems perform a translation automatically (a case in point being FTP in ASCII mode). But not all. Here is a translation chart I found on the web : http://www.natural-innovations.com/boo/asciiebcdic.html

RE: Increasing Freelists?

Wow, must be in a new version of oracle. Like 8.0.0.0.1 :) -Original Message- Sent: Friday, June 15, 2001 4:57 PM To: Multiple recipients of list ORACLE-L You can do an alter table TABLENAME storage freelists N - Original Message - To: Multiple recipients of list ORACLE-L

RE: Oracle 8i installation problem

why is the directory/filename for pfile in quotes? joe [EMAIL PROTECTED] 06/18/01 10:21AM David, As I had mentioned, the dbassist utility fails in the3rd step at 82%. At this point, it gives the error "Oracle not Available" and the only option that I had was to Ignore Abort. I clicked

RE: Oracle 8i installation problem

Pankaj A couple of possibilities: - 1) Try using single quotes (or no quotes) around the pfile path rather than double quotes. 2) In your environment, I noticed that you had PATH=$PATH:ORACLE_HOME/bin. It should be PATH=$PATH:$ORACLE_HOME/bin ^ HTH

transfer of large datafile Oracle7.3.4.4 databases to 8.1.7.1.3

Has anyone successfully transferred large datafile Oracle databases from Oracle7.3. to 8.1.7? By large datafile database I mean a database that has files over 2G in size. This may not apply to all, it may apply only to those who extended the files beyond 2G. Just curious, since many of you

RE: 9i On Linux

how far did it get before it died? joe [EMAIL PROTECTED] 06/18/01 09:30AM Failed to install on rh7.1, PIII-450/256M (512M Swap).The installation consumed 460M Swap at max.Roger Liu-Original Message-Sent: Friday, June 15, 2001 4:21 PMTo: Multiple recipients of list ORACLE-LCan any

job searhing in austria

Hi , I am searching job in austria . do you konow web site adress about job oppotunutess in austria or is there any body who works in austria. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arslan Bahar INET: [EMAIL PROTECTED] Fat City Network

Re: the conversion is from Mainframe flat file to Unix Flat

Extended Binary Coded Decimal Interchange Code -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access /

Installed Product Info

We have installed 8.1.6 on several AIX nodes and some of them are showing no installed product thru OUI. We would like to have _all_ of them look the same without having to re-install oracle. I think I remember someone saying that there is/are file(s) that keep this info. Does anyone know what

RE: 9i On Linux

And you believe the propaganda? Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, June 18, 2001 9:50 AM To: Multiple recipients of list

OT RE: 9i On Linux - time to start bashing.

Well, maybe I am smoking crack, but Win2K Pro is running dandily on my 266 MHz, 96 MB RAM laptop. Couldn't be happier with it. -Original Message- Sent: Friday, June 15, 2001 6:12 PM To: Multiple recipients of list ORACLE-L I think that 192 MB makes sense - as MS definitely wants

RE: Multiple databases under the same ORACLE_HOME

Title: Multiple databases under the same ORACLE_HOME If it is the same installation it is under the same home, it's just a different SID. Aren't I right on this? Kev -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Andrey BronfinSent: Monday,

export fails with an EXP-0079 ERROR

Hi I am getting the following error message. EXP-00079: Data in table RRR is protected. Conventional path may only be exporting partial table. I am unable to export from system user with full=y option.I am able to export from sys user.How can I export from system user. Thanks -Seema

RE: Backups on raw devices

I've logged a TAR on this one with Oracle. They have verified what I suspected all along. The SAs here don't understand how Oracle performs a hot backup. There is no difference between raw and cooked file systems as far as Oracle is concerned when performing a hot backup. Also, the skipping

RE: Multiple databases under the same ORACLE_HOME

Title: Multiple databases under the same ORACLE_HOME I have figured it out ! Thanks a lot to everybody who responded ! -Original Message-From: Andrey Bronfin Sent: Monday, June 18, 2001 4:56 PMTo: Multiple recipients of list ORACLE-LSubject: Multiple databases under the

RE: OT: Working from home

I believe that was counting lines of code per person/day over the entire development lifecycle, so some days you actually write no code because you were writing documentation, or sitting in meetings eating donuts or whatever. COBOL can actually be measured fairly well in terms of lines of code

MOVE PARTITION

Title: MOVE PARTITION Helo all, How can i move one or more paritions from one tablespace to another. I checked the objects for TSPITR, in that some of objects are in SYSTEM tablespace. Any help pls. Nirmal.

Size of SYS1ORCL.ORA

Hi PLEASE HELP! I have Oracle Workgroup Server 7.3 for Windows NT. How to manage size of database files, when they grow to big? For example, my SYS1ORCL.ORA filehas over 376 MB. What to do, to decrease it? I'm running out of disk space and all the user data are on separate tablespace

RE: Multiple databases under the same ORACLE_HOME

Yes. Each db gets its own service, created by you, using the oradim command (and/or two services, and/or oradim80, both depending on the version of Oracle you're running.) You would want to separate the db's data files from the Oracle_Home anyway. The only thing in Oracle_Home would be the

RE: 9i On Linux

Roger, I don't believe that Oracle9i is certified on Redhat at the moment. There had been a lag in certification between Redhat and Oracle in the last few months. This situation has been resolved and certification has been restarted between Redhat an Oracle. I think you will have to wait for

RE: OT RE: 9i On Linux - time to start bashing.

er, the Win2K, I meant. Not the crack. :-O -Original Message- Sent: Monday, June 18, 2001 11:17 AM To: Multiple recipients of list ORACLE-L Well, maybe I am smoking crack, but Win2K Pro is running dandily on my 266 MHz, 96 MB RAM laptop. Couldn't be happier with it.

RE: 9i On Linux

Hi, The recommendation is definitely 512MB RAM + a swap partition of twice that size. I installed on Suse 7.1 with 512MB RAM and a 600MB swap partition and encountered relatively few problems. RedHat should be OK as it's based on the 2.4 kernel. I can't recommend Suse highly enough though.

how to rename a database SID

Title: how to rename a database SID HI ! How can i rename a database on NT / UNIX ? Thanks a lot in advance !

RE: Multiple databases under the same ORACLE_HOME

Yes it is possible to have mutiple under same oracle home in windows nt. The only thing to do is just go to console and type set oracle_sid=new_sid then create the database with this new sid and thus u can have two databases runing at same time on windows nt --- Kevin Kostyszyn [EMAIL PROTECTED]

RE: ORA-09782 ORA-09783

Here is the problem . Use SET instead of REUSE CREATE CONTROLFILE REUSE DATABASE "PROD" RESETLOGS ARCHIVELOG instead use CREATE CONTROLFILESET DATABASE "PROD" RESETLOGS ARCHIVELOG Brijesh -Original Message-From: Catherine LeBlanc [mailto:[EMAIL PROTECTED]]Sent: Sunday,

Oracle Database setup document

Dear All, I will be shortly setting up 2 new Oracle Databases for my company, for the development system, before we hopefully go into production in 3 months time. What I would like to do is document the proposed setup off these databases before I start doing the actual work. Therefore, is

Re: export fails with an EXP-0079 ERROR

On Jun 18, 2001 at 08:36:36AM, Seema Singh wrote: Hi I am getting the following error message. EXP-00079: Data in table RRR is protected. Conventional path may only be exporting partial table. I am unable to export from system user with full=y option.I am able to export from sys

Unix HEAR file help

List, A few years ago I used a HEAR file to kick off a FTP transfer. Now I need to do it again and can't recall the procedures for creating and using the HEAR file. ( I have been away from Unix using Windoze and Novell and I have created a Linux Test box) I remember seeing a post about a HEAR

NT Script

Hello all, I know, I know, NT. Anyway, I was wondering if anyone knew how to append the system date to a file created through a script. Basically, what I want to do is have files set up to run exports every night, however, I need to be able to appened the system date to the file when it

Jdeveloper 3.0

I accidentally deleted a thread someone posted last week about connecting to a db with Jdeveloper. I am not sure that anyone answered the question, I would say to add the TNS_ADMIN key to the registry and point it to the proper TNSnames file, that might solve the problem. Sincerely, Kevin

RE: export fails with an EXP-0079 ERROR

May be this helps identifying what's going on : EXP-00079 Data in table %s is protected. Conventional path may only be exporting partial table. Cause: User without the execute privilege on DBMS_RLS, the access control package, tries to export a table that has access control. Since table owner

RE: Multiple databases under the same ORACLE_HOME

Title: Multiple databases under the same ORACLE_HOME We used to have 4 database instances under the same home on NT. IT worked just fine. In order to set them up we used the ORADIM command and created the services. Once this was done we set the SID and created the DB . Worked fine.

RE: how to rename a database SID

Title: how to rename a database SID See Note Note:15390.1Subject:How to Determine and Change DB_NAME or ORACLE_SID on MetaLink Here it is below Rick Purpose This entry describes how to find and change the "db_name" for a database, or the ORACLE_SID for an instance, without recreating

Re: how to rename a database SID

just recreate database control file. On Mon, 18 Jun 2001, Andrey Bronfin wrote: HI ! How can i rename a database on NT / UNIX ? Thanks a lot in advance ! -- Lucy Lin Oracle DBA condenet.com 212-286-3852 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lucy

RE: Backups on raw devices

You can put the repository anywhere you like. Even on the production box. But that will mean you will need to recover the RCAT, then the production database. If you have the resourcs, put the RCAT on another box to backup production. Walking on water and developing software from a

Re: transfer of large datafile Oracle7.3.4.4 databases to

Patrice, I built a test server with 8.1.7 and migrated the data from 7.3.4. The database contains 70 GIG of data. I was unable to export the data (free disk space limited on the Novell 7.3.4 server) so I built the database and created the datafiles sized to fit the partitions for the data. The

RE: JDeveloper Connection to Oracle DB

JDBC thin driver does not use Net8. Another JDBC driver uses Net8 - OCI calls. Alex Hillman -Original Message- Sent: Saturday, June 16, 2001 5:00 PM To: Multiple recipients of list ORACLE-L Elias, I don't know much about JDBC, but I suspect that like ODBC it sits on top of the Net8

RE: Installed Product Info

I believe you can find it in $ORACLE_BASE/oraInventory. g. -Original Message- Sent: 18 June 2001 17:31 To: Multiple recipients of list ORACLE-L We have installed 8.1.6 on several AIX nodes and some of them are showing no installed product thru OUI. We would like to have _all_ of them

Re: NT Script

I did this on another server and can't remember the exact details, but it went something like this: 1) In SQLPlus create a rename.sql file with: Spool rename_export.bat select 'HOST REN export_file_name export_file_name_'||to_char(sysdate,'MMDD') FROM DUAL; spool off; 2) In your script

RE: transfer of large datafile Oracle7.3.4.4 databases to 8.1.7. 1.3

FYI, Oracle Support confirmed that I hit a 2G file size limit for Oracle databases on NT. This probably led to data dictionary corruption. I don't know if this is an NTFS limitation or Oracle on NT problem, but at this point I don't care, I can fix this by creating multiple smaller datafiles

Re: Oracle Database setup document

Joe's got the right idea. I do this regularly. By letting dbassist write the base scripts I don't have to worry about my fat fingers typing the wrong stuff for the auto-generated parts. Then customize as necessary for your needs. Works great. Rodd Original Message dated 6/18/01, 1:26:09

RE: Installed Product Info

Terry, Oracle 816 maintains inventory location depending on your $ORACLE_BASE environment variable settind during Oracle installation. Ours is Solaris environment. On solaris following directories contain inventory info. 1. /var/opt/orace --- After the installation, a text file by name -

Re: Unix HEAR file help

man ksh and search for here-document. Everything you need to know. Ron. RROGERS@galot

RE: Unix HEAR file help

here document -Original Message- Sent: Monday, June 18, 2001 1:21 PM To: Multiple recipients of list ORACLE-L List, A few years ago I used a HEAR file to kick off a FTP transfer. Now I need to do it again and can't recall the procedures for creating and using the HEAR file. ( I have

Installing oracle remotely

Hi Is it possible to install oracle 8i from remote site say thru telnet. What i know is oracle 8i installation is gui based. I tried a lot but was not able to install remotely. Can anyone help me in solving this problem. Also if it is possible to install oracle remotely please tell me how to do

RE: how to rename a database SID

You must also change the dbname parameter in the init.ora file -Original Message- Sent: Monday, June 18, 2001 2:18 PM To: Multiple recipients of list ORACLE-L just recreate database control file. On Mon, 18 Jun 2001, Andrey Bronfin wrote: HI ! How can i rename a database on NT /

RE: Backups on raw devices

We have three separate databases (RCAT80, RCAT815, and RCAT817) which reside on a separate, small, UNIX box that we only use for backups. All the 8.0.4 databases are backed up to the RCAT80 database, 8.1.5 databases to RCAT815, and 8.1.7 databases to RCAT817. Each of these databases has it's

RE: RE: NT Script

Kevin, sorry, I got notified that the .BAT file was stripped. below is the text of the BAT file. Simply copy it into a notepad document, and name it TODAY.BAT rem rem echo off IF NOT '%1'=='' GOTO SetEnvVars for /F delims=/ tokens=1-4 %%i in

RE: NT Script

Kevin. Stick to what you are good at. Are you good in working with sqlplus? Leverage that skill into making your export .par file dynamic. Call an sqlplus script that produces (spools) either the export.bat (and include the file=path in the command line) or the export.par file. In this

Re: Installing oracle remotely

I use Secure Shell (ssh), with X11 tunneling/forwarding. For this to work, you need to be running an X server on your local machine. If you are running Linux or any version of Unix locally, you should be set. If you are running any version of Windows, you will need to download and install an X

RE: how to rename a database SID

Title: how to rename a database SID Uday: You forgot one important step. In the 'create controlfile' command line, where you change the database SID you must add the word 'SET'. For example, if the trace file was created as... CREATE CONTROLFILE REUSE DATABASE "OLDSID" NORESETLOGS

RE: transfer of large datafile Oracle7.3.4.4 databases to 8.1.7. 1.3

Question, What were the problems you ran into with this? I have a 4 gig datafile on NT 4.0 with Oracle 816 SE. I don't believe we're experiencing any problems. kev -Original Message- Patrice J Sent: Monday, June 18, 2001 1:51 PM To: Multiple recipients of list ORACLE-L 8.1.7.

RE: transfer of large datafile Oracle7.3.4.4 databases to 8.1.7. 1.3

What version of Oracle? What version of Windows? Todd Carlson Oracle 8i Certified DBA Bunge North America

RE: NT Script

Paul, Does that mean that we should never stretch and try and learn something new? I would prefer to have several scripting tools in my toolbox, rather than depend on knowing SqlPlus ONLY for scripting experience. While what you suggest is certainly clever, and probably works just fine, I

RE: Oracle Database setup document

AFAIK, dbca will not generate tablespace create scripts with LMTs. so edit the storage clause of each tablespace before running the script set. Paul -Original Message- Sent: Monday, June 18, 2001 2:55 PM To: Multiple recipients of list ORACLE-L Joe's got the right idea. I do this

RE: Unix HEAR file help

try: ftp EOF 123.123.123.123 userid password get location1/file location2/file bye EOF Brian Norrell Manager, MPI Development QuadraMed 511 E John Carpenter Frwy, Su 500 Irving, TX 75062 (972) 831-6600 -Original Message- Sent: Monday, June 18, 2001 12:21 PM To: Multiple recipients of

Externally Identified User - Serious Weirdness

Hope everybody had a good weekend - Working on HP-UX and Oracle 8.1.7.0.0 I've got a third party app that 's written in COBOL and stores some of the information it needs to generate screens in the database. I am trying to practice restoring this beast, and it turns out I must run a utility to

RE: transfer of large datafile Oracle7.3.4.4 databases to 8.1.7. 1.3

Oracle 8.1.7. on NT, and NT 4. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO |

RE: XDK 9i work with 8i ?

Kris, Not exactly an answer to your question, but I installed XDK 817.1.A in my 816 database, and it works fine. I would suggest that you created an 8i test database (you should have one installed someplace, anyway, for this kind of testing), and try and install the 9i XDK packages. In theory,

XDK 9i work with 8i ?

hi, a programmer has requested DBAs to install XDK 9i. we have 8i installed. he needs to validate some XML against XSD schemas. unfortunately, XDK 8i does not have the functionality he needs. does anybody have any experience using the XDK 9i and if it'll work if installed for an 8i database on

RE: Installing oracle remotely

yes...vnc bad over phone lines, but if the installer is running in script vice 24million color mode, praps a good hack? good thoughts -Original Message- Sent: Monday, June 18, 2001 3:01 PM To: Multiple recipients of list ORACLE-L remote control the WinNT desktop. VNC

RE: transfer of large datafile Oracle7.3.4.4 databases to 8.1.7.

A few platforms have that problem where if you autoextend over 2Gb you will corrupt the file. I Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 18, 2001 1:51

EXPORT questions

hi What is diffrent between the full export taken by sys user and system user? Why people prefer the system user to take full export? If any one can take full export with sys user in FGAC case then how to import incase of recovery means from sys user itself likefollowing command. imp

Reorg wizard, batch mode, Solaris

Title: Reorg wizard, batch mode, Solaris Hello, I'm looking for a reorg wizard job that I can put in cron to reorg two notorious tables while they are online. Has anyone written one, and if so, may I have a copy? Thanks so much. Linda

Vertiginously OT RE: NT Script

Yea, Paul, what gives? Are you saying that we should all just stop learning, give up, FDISK /MBR our NT hard drives, Bobbetize our nether parts and head for the coast? Huh? Are ya? Gawd, I wish Eric were here; he'd slap you around with the Barbie you so clearly need. :) (that was the

RE: Backups on raw devices

You can just use the controlfile so you don't have to setup a database repository. Here's a clip from page 2-8 of the User's Guide: When you use a control file as the RMAN repository, RMAN still functions very effectively. If you choose not to use a recovery catalog, follow the guidelines in

RE: Space Manager vs. Live ReOrg vs TS ReOrg

I agree with Kevin. I always use hand-made scripts. There is a risk with any 3rd party tool. There are version issues, patches, OS issues, etc. Scripts, on the other hand, can be customized to do the exact amount of work at the exact time you want it done. Cheers, Earl --- TheOracleDBA

RE: Installing oracle remotely

We do it using an X based system such as VNC. Out machines are at co-locations around the US. -Original Message- Sent: Monday, June 18, 2001 1:18 PM To: Multiple recipients of list ORACLE-L Hi Is it possible to install oracle 8i from remote site say thru telnet. What i know is

RE: Vertiginously OT RE: NT Script

What the?:) -Original Message- Sent: Monday, June 18, 2001 4:22 PM To: Multiple recipients of list ORACLE-L Yea, Paul, what gives? Are you saying that we should all just stop learning, give up, FDISK /MBR our NT hard drives, Bobbetize our nether parts and head for the coast? Huh?

RE: transfer of large datafile Oracle7.3.4.4 databases to 8.1.7.

Just make sure , when you do this, that your max_datafile parameter on the Database is set high enough. -Original Message- Sent: Monday, June 18, 2001 12:51 PM To: Multiple recipients of list ORACLE-L 8.1.7. 1.3 FYI, Oracle Support confirmed that I hit a 2G file size limit for Oracle

RE: NT Script

Hello, If you want to do this in a .BAT or .CMD file then: for /f tokens=2-4 delims=-/ %%i in ('date/t') do set filedate=%%i%%j%%k rename filename export%filedate%.exp HTH -- Chris J. Guidry P.Eng. ATCO Electric, Metering Services Phone: (780) 420-4142 Fax: (780) 420-3854 Email: [EMAIL

Re: Externally Identified User - Serious Weirdness

David, Is FA_IDNT a view that you didn't know about that the package uses? Just a thought. ROR mª¿ªm [EMAIL PROTECTED] 06/18/01 03:16PM Hope everybody had a good weekend - Working on HP-UX and Oracle 8.1.7.0.0 I've got a third party app that 's written in COBOL and stores some of the

RE: Calcs between two rows of same table. (NEVERMIND)

DOH! Answered my own question... select max(MYCOUNT)-min(MYCOUNT) from MYTABLE group by round(rownum/2+.5)*2 UNION select max(MYCOUNT)-min(MYCOUNT) from MYTABLE group by round((rownum-1)/2+.5)*2 If I had just experimented 1 more minute

RE: transfer of large datafile Oracle7.3.4.4 databases to 8.1.7.

On NT 4.0, Oracle 8.0.5 2gig filesize is not a limitation of either NTFS or Oracle. I have several datafiles in the 3-5gig size. Rick -Original Message- Sent: Monday, June 18, 2001 4:31 PM To: Multiple recipients of list ORACLE-L 8.1.7. Just make sure , when you do this, that your

Why am I not getting ORA-04031 errors in my alert log?

We were seeing ORA-04031 errors in our log files from exports and rman backups on a recently migrated 8.1.7 database on Sun Solaris 2.6. Our end users of our web-based applications were also seeing ORA-04031 errors upon executing their application. We increased shared pool size and

Horrifically, Vertiginously OT RE: NT Script

mock horror on Wow, you have reproduced?!?!? mock horror off :) butto answer your provocative question: Neither! I was a consultant too. The lies...the deceit. The constant learning of new tricks favored by each client. A different job every day. The anonymous calls...all the package

configuring management server 8.1.7

Does anyone know of a good document outlining the installation and configuration of the Oracle Management Server v 8.1.7? Also important would be the relationship between management server (service on NT), the intelligent agent and the required repository. Any assistance would be greatly

RE: Horrifically, Vertiginously OT RE: NT Script

LoL! Every sect needs its special liquid... water, wine, kool-aid, and my own personal favorite: single malt scrotch. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, June 18, 2001 5:46 PM To: Multiple recipients of list ORACLE-L Just sip the purple kool-aid...

RE: Calcs between two rows of same table. (NEVERMIND)

If you are on 8.1.6 or above, check out the new LEAD sql function. Ron. Rich.Jesse@qt

  1   2   >