RE: 2 Databases Problem

Hi , if I'm not wrong, it's because there is another instance use the same db name. check ur initSID.ora regards -Original Message- Setiawan Sent: Wednesday, March 28, 2001 2:45 PM To: Multiple recipients of list ORACLE-L Dear Listers , yesterday , I've created 2nd database for Test

'Event Group Latch'

Tom Kyte (asktom.oracle.com) kindly posted me a reply to my question on the above latch. For anyone interested, the description is below Cheers Connor -- START QUOTE Event Group Latch Usage This latch is used during the following operations : An "alter system set events.." command. During

RE: Issues with Oracle on a Compaq Tru64 5.1 Cluster

Is this problem specific to the cluster solution or has it manifested itself on non-clustered setups ? We are about to implement a Tru64 5.1 Oracle 8.1.7 system. As I cannot access the tar you mentioned could you please forward on the instructions. Regards Lee -Original Message-

Re: changing db_block_size

I have read the same : different blocksizes per tablespaces in Oracle 9i. --- Rachel Carmichael [EMAIL PROTECTED] a crit: no flame supposedly in 9i you will be able to change the block size while the db is up and will also be able to have different blocksizes -- I think it's by

Oracle variables; LD_LIBRARY_PATH TNS_ADMIN

Hello, I need some clarification. What is the significance of the Oracle variables, TNS_ADMIN LD_LIBRARY_PATH? When are the 2 used or what effects what in the environment? Also please if some one knows how do I monitor an Oracle Parallel Server? Any good book where I can read about OPS?

Re: Trying to find a book...

Rocky ! I guess you are talking about his OCP TEst prepration guide. I think it is published by new riders. A quick search on AMAZON.com will give you more detaiils - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001 2:45 AM

RE: Import comma-delimited text file into Oracle

Helmut, I believe that SQL*Loader is the quickest way to load your data. You could write a procedure that uses UTL_FILE also. And there is another choice, but truly brute force - you could edit your file into INSERT statements and load it through SQL*PLUS. :-( Ron Morton Union Switch Signal

RE: Exp Imp Overwirte posiible or not?

Hi , destroy=y option doesn't meet the requirement . I checked the oracle docs and didn't find any option to overwrite data.I think i have to truncate data and then insert into appropriate tables as william pointed out. Thnaks to every one who responded. Azhar Siddiq,

Is terminal release of 8.0.x still supported?

We have some 8.0.4 databases running on Sun Solaris. I believe that 8.0.4 has been desupported as of December 31, 2000. We are unable to upgrade one of our apps at this time that is running on an 8.0.4 database. Is the terminal release of 8.0.x still supported? If yes, what is that terminal

Re: New born DBA.....

Sinardy Xing wrote: Hi guys, I am a new DBA, can you please tell me what are the common task list as DBA for Oracle8i on Solaris 7. I mean things that I should do and check regularly. I know backup is one of them. shameless plug get the book _Oracle DBA 101_ it has not only that kind

Re: LOB ?

Thank you Winnie. Thats exactly what I was looking for! Gene [EMAIL PROTECTED] 03/27/01 04:42PM I am not quite sure that you can reference a LOB in a remote database through a database link. You are very likely to get the ORA-22992 error when you attempt to do so. 22992, 0, "cannot

RE: What is best practice - differenet schema/different dbs

Hi Doug , (and all) , Just curious - the PS environment, do you put finance and HR on the same DB? Do you share the sysadm user? I'm new to this PS stuff, so this interests me. Also, in production, do you have the PS databases separated from the other OLTP databases? Thanks Mike Lanteigne

Re: changing db_block_size

To change the block size you have to recreate the database. How you are going to copy the data that's another issue. You can use full database export/import (pretty long downtime, or problems with data consistency) or you can do a live copy. More on a live copy you can see in: Venkat S.

RE: Issues with Oracle on a Compaq Tru64 5.1 Cluster

Lee, Be sure to check the alerts on Metalink for Tru64 (Product Lifecycle, Alerts). There are OS level patches requried for nonclustered systems. See Note 132391.1. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 03/28/01 03:00AM Is this problem

RE: Import comma-delimited text file into Oracle

Or you can write a program in (C, Perl, Java, etc) to parse the file and do inserts. Richard -Original Message- Daiminger Sent: Tuesday, March 27, 2001 10:36 PM To: Multiple recipients of list ORACLE-L Hi! Is SQL*Loader the only way to move the contents of a comma-delimited ASCII

RE: New born DBA.....

Also there is a book by Heidi Thorpe Oracle 8I Tuning and Administration where there is a big chapter about database monitoring. Alex Hillman -Original Message- From: Joseph S. Testa [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 9:20 PM To:

several peoplesoft databases (schemas) in one Oracle database

Can anybody give me pro and con for having let say several Peoplesoft schemas in the same database versus in different databases. Should objects of different schemas be in the same tablespaces or every schema should have it's own set of tablespaces etc. Alex Hillman -- Please see the official

Metalink customer satisfaction surveys

Have any of you received one of those lately? I remember last year they used to check with us to see whether we were happy with the service, but I have received nothing in a long time. Someone soft closed one of my TARs, saying he had sent me the information I requested, but I can't find

RE: New born DBA.....

Here is a quick list: Daily checks - Oracle Alert file logs - system resources - backups - archive logs - error logs Weekly checks - free space in Tablespaces, Tables, Indexes and Clusters Monthly checks - fragmentation in Tables, Indexes and Clusters Ben Poels Queen's University

Re: RMAN

I put mine right before I do an archivelog backup, which I do at the end of my level 0 and level 1 backups. But if I was not doing an archivelog backup I would not even archive my current log because there would be no reason to do so,. HTH, Ruth - Original Message - To: "Multiple

Backup Advice.

Hi there :) After a rather interesting start of my week, I have a question for you about the backup of local PC test databases. Rant At the end of last week I deleted my current test database along with all Oracle files, and went for a fresh install, due to having some rather interesting

RE: . . .Compaq Tru64 5.1 Cluster / SAN?

Thanks for the heads up. We are also planning upgrades from 40F to 5.1 nonclustered with Oracle 8.0.6. Has anyone considered or implemented Compaq's SAN architecture? Mike Hand Polaroid Corp -Original Message- Sent: Wednesday, March 28, 2001 7:56 AM To: Multiple recipients of list

Re: Oracle variables; LD_LIBRARY_PATH TNS_ADMIN

Oracle, by default, uses $ORACLE_HOME/network/admin to stor the tnsnames.ora, sqlnet.ora, listener.ora, snmpro.ora and snmprw.ora files for configuration of the Net8 services. If you declare a TNS_ADMIN variable oracle will use that location for these files. It allows you to keep your

RE: What is best practice - differenet schema/different dbs

Just my $.02. I agree separate tbs for different app schema's. However, I would separate applications to their own db, especially if they are 3rd party apps. You have much less control on COTS. Some run their install scripts as sys. I don't agree w/ it, but I am not going to rewrite their

Re[2]: changing db_block_size

Joe, No flame. There are other methods of doing the job, but the work!!! Spooling all the data out to comma delimited files, creating all those DDL scripts!! You'd have to be a masochist or else into some HEAVY re-engineering! Dick Goulet Reply

Is there any Access user group?

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Opinions on this book...

Hi Gang, Happy Wednesday! Has anyone read this book? I'm interested in what you thought of it. Thanks, -Rocky --- K Gopalakrishnan [EMAIL PROTECTED] wrote: Rocky ! I guess you are talking about his OCP TEst prepration guide. I think it is published by new riders. A quick search on

Re: OFF TOPIC: java servlet service provider

try elance.com -- email: [EMAIL PROTECTED] Oriole Corporation (http://www.oriole.com/) Oracle Performance Tools and Free Scripts Tel: +44 (0)20 7872 5480 Faxes: UK +44(0)705 066 8661 / US +1 240 526 5946 - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]

RE: New born DBA.....

You could also download and use the following checklists which are always handy to refer to when starting up: http://www.geocities.com/tbcox23/dba_checklist13.doc http://pillango.sirma.bg/oracle/N008_dba_checklist.pdf Good luck on that HUGE rollercoaster of a learning curve ORACLE!! HTH Mark

Re:Using Profiles to Force Users off After Inactivity

Ian, From what I've seen on 8.1.6 8.1.7 it still does the non immediate kill changing the session status from active/inactive to sniped, but it does release locks a whole lot faster. Dick Goulet Reply Separator Author: "MacGregor; Ian A." [EMAIL

Re: changing db_block_size

I'd be interested in seeing that presentation, when are you presenting? I'll be there doing the logminer thing on tuesday late afternoon, last session before BIG BASH. thanks, joe To change the block size you have to recreate the database. How you are going to copy the data that's another

Intermedia violates own constraint.

Hi. I had some problems with getting Intermedia to work after patching to 8.1.7. I got a ORA-04045: errors during recompilation/revalidation of CTXSYS.CONTEXT ORA-29835: ODCIGETINTERFACES routine does not return required interface(s) When trying to create an index. Searched Metalink, and

RE: 'Event Group Latch'

Title: RE: 'Event Group Latch' Thanks, Connor! -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 2:56 AM To: Multiple recipients of list ORACLE-L Subject: 'Event Group Latch' Tom Kyte (asktom.oracle.com) kindly posted me a reply

Real Workstation Requirements

My firm is currently using Oracle Applications 10.7SC and are in the planning stage for 11i. I have been tasked with finding the Workstation requirements for 11i. The Workstations will be running Windows 2000 with Microsoft Office, email client and a number of smaller financial applications. I

Re: Someone changed INTERNAL password URGENT

Hi Alex, Are you sure in Unix you do not need password for internal if you are member of DBA group ? -- neena "Hillman, Alex" wrote: If you are on unix - you do not need internal password if you log in as member of dba group. On NT before 8.1 you need internal password

Slightly off topic SFTP

DBA's, Has anyone been able to automate secure ftp "sftp"? I have several cron jobs that move an ascii file from one box to annother via cron jobs shell scripts. The security gestapo is now making us use ssh and sftp. I haven't been able to figure out the syntax to get sftp automated.

RE: Real Workstation Requirements

I would say no Celeron processor for sure, I would go with PIII's 500 or above, minimum 128 RAM 256 would be better, at least a 10 gig hd. We use Dell Optiplex workstations, most of them are 500's and we don't run into any problems, most of them have 10 to 20 gig hd's and 256 mb's of RAM. Kev

Re: New born DBA.....

Check out First Steps on our site. -- email: [EMAIL PROTECTED] Oriole Corporation (http://www.oriole.com/) Oracle Performance Tools and Free Scripts Tel: +44 (0)20 7872 5480 Faxes: UK +44(0)705 066 8661 / US +1 240 526 5946 - Original Message - To: "Multiple recipients of list ORACLE-L"

RE: Opinions on this book...

I have W. Baird's book, "Oracle OCP". Unless there is a newer edition out it only covers Oracle 7.x, not 8 or 8i. I used it to help me pass the first OCP exam, SQL and PL/SQL. It was adequate for that if you also have considerable SQL experience with Oracle or other DBMS's. For the second exam,

Standard vs Enterprise Edition

Title: Standard vs Enterprise Edition Due to Oracle's licensing shenanigans, we are looking at the use of the Standard edition to save . In fact, our management may even make Standard the de facto standard while requiring justification for Enterprise. If anyone is currently using

Re:several peoplesoft databases (schemas) in one Oracle data

Alex, We've done both. Is there a down side, yes on both counts. With multiple Peoplesoft schema's your tablespaces need to be bigger, like initial size times number of schema's plus fudge factor. Also you can get IO bound on certain tablespaces, like PSINDEX real fast. You really

RE: Is there any Access user group?

Access User Groups... Sure, most High Schools have Groups that meet to discuss such things...I think they call them Clubs though! I've heard they provide some really neat technical discussions like..."How to Convert your Parents Paper-based Contact List into Access"..."Access 2000: Breaking the

Re: Metalink customer satisfaction surveys

I had a call from Oracle Support about three weeks ago for a telephone Metalink customer satisfaction survey. What an opportunity;-)... I let them know it was unusably slow, inconsistent (call something the samething throughout what a concept), can't fing basic things like patches, no

RE: sqlplus

Ravindra, try using 'trunc' on your group by clause. -Original Message- Sent: Wednesday, March 14, 2001 7:11 PM To: Multiple recipients of list ORACLE-L Can we use the group by clause on a date column.I am written a query to get a count(*) of records with a group by clause on the date

Re: parallel server; ops setup

Hi, I'm in digest mode, so here's reply to those OPS questions... I don't think you can set up OPS without a hardware cluster. In fact, if you don't turn on the Lock manager at the os level the Oracle installer won't even show OPS as an installation option! As for other other question re.

RE: Standard vs Enterprise Edition

Title: Standard vs Enterprise Edition We also have a client that wants to use Standard because it is less expensive. I tried to install 8.1.6 SE on an NT server that already had EE on it. I made it a multihomed machine but ran into a problem with a dll. Seems to be a known bug, needless to

Re:Standard vs Enterprise Edition

Jeff, Yes we use Standard and Enterprise. Do you lose some things, yes. Does it matter, depends on the application. In our case we could work around those restrictions without problems. Otherwise it's a good ploy to save a buck. Dick Goulet Reply

OFFTOPIC RE: sqlplus

Title: OFFTOPIC RE: sqlplus This post would have been ALOT funnier, if Ravindra's name was, instead, Ganesh. (Sorry about all you folks that don't like Hindu Mythology based puns.) -Original Message- From: Bala, Prakash [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001

Error: Failure to get normalized flag.

We batch load data into an application called Oracle Clinical. The batch load failed and gave the error: "Error: Failure to get normalized flag." Could low tablespace indirectly cause this error? Any help/ suggestions would be appreciated. Jenah Sigurdson -- Please see the official

Re: Backup Advice.

Mark, I might suggest that you look into a "Ghost" product for making an image of your PC. I "ghost" my pc and keep the image on the network where it is backed up each night and stored on tape. If I have problems with my PC I load the image to the second drive and I have access to all of the

Response times with different multiblock read count

Hi All, I am running a test query with different db_file_multiblock_read_count to test the overall throughput. environment: oracle 8.1.6 on hp-ux v11 db_block_size : 16k system is using LVM and file system is using buffered I/O and disk is mirrored but not stripped. I was expecting

RE: SQLCode in 8i

Regina, try sqldbcode. This will give the exact Oracle return code. Prakash -Original Message- Sent: Wednesday, March 21, 2001 9:05 PM To: Multiple recipients of list ORACLE-L We have a number of Powerbuilder applications for which we have been using the SQLCode returned from a sql

RE: Is terminal release of 8.0.x still supported?

The terminal release of Oracle8 is 8.0.6. Not sure of the desupport date, even though I have 4 databases running it. I really don't worry to much about the desupport date. As a general rule if it ain't broke I don't fix it. Granted we are going to 8.1.7 on most of them but that is to get a

RE: What is best practice - differenet schema/different dbs

Actually I meant Dick, nor Doug, sorry Mike -Original Message- From: Lanteigne, Mike [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 8:35 AM To: Multiple recipients of list ORACLE-L Subject: RE: What is best practice - differenet schema/different dbs Hi Doug ,

Re: Support rational

well the concept of support is you pay for it and it covers all versions(at leats until desupported which seems quick nowadays). hence the concept of "free" version upgrades :) joe From: "O'Neill, Sean" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L

RE: A Basic PL/SQL Question

Another option is to create a table with a large varchar2 column and insert the data row by row. You can then spool a SELECT from that table to a file. e.g. create table hold_output (mytext varchar2(4000) tablespace ts_small; -Original Message- Sent: Tuesday, March 27, 2001 4:09 PM To:

Re: Standard vs Enterprise Edition

We use it for all of our small, under 10 gig, NT databases (at last count we had 13). Many of the features of Enterprise are just not needed for these systems because the user/data volume is small and we are not using replication or fine-grain access control. All of the 3rd party applications

Re: Problems with export/import

Maybe there are several things you want to check on your table in database B 1) Do you have any trigger on that table? 2) Do you have any foreign key constraints on that table? 3) Is that table structure the same on 2 databases? Winnie "Helmut Daiminger" [EMAIL PROTECTED] on 03/28/2001

RE: SQLCode in 8i

Thanks for the suggestion, Prakash, but SQLDBCode is also returning 0 for no rows found. At 08:25 AM 3/28/01 -0800, you wrote: Regina, try sqldbcode. This will give the exact Oracle return code. Prakash -Original Message- Sent: Wednesday, March 21, 2001 9:05 PM To: Multiple recipients

RE: . . .Compaq Tru64 5.1 Cluster / SAN?

We are doing that here, we have a 7 ft. tall SAN frame with dozens of hard disks laying about in boxes, with two es-40s also in boxes. We plan to have that put together by mid April. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans

Re: Bad Cookies with Internet Application Server 1.0

Did someone change the password of the app logging into the db? [EMAIL PROTECTED] 03/28/01 11:40AM We've been running iAS 1.0 for several months without problems. Now users who have already been verified are at times getting the following error when they move to a new URL.

Problems with export/import

Hi! I'm having weird problems with exporting/importing tables... First I run an export on database A About to export specified tables via Conventional Path ... Table(T) or Partition(T:P) to be exported: (RETURN to quit) tbclocktimes . . exporting table TBCLOCKTIMES

RE: Real Workstation Requirements

Thanks [EMAIL PROTECTED] 03/28/01 12:05PM I would say no Celeron processor for sure, I would go with PIII's 500 or above, minimum 128 RAM 256 would be better, at least a 10 gig hd. We use Dell Optiplex workstations, most of them are 500's and we don't run into any problems, most of them have

Re: Standard vs Enterprise Edition

Sometimes I forget that unhappiness is only based on perception. "Thater,

FW: [Fwd: Response times with different multiblock read count]

Prasad, the difference here is : select count(*) does not require the data in all of the columns. if you are going to be including columns that return a large amount of data, then the larger reads should help. As its most likely that the OS read size is 64 KB, it makes sense that a local

online backup query

Hi gurus I am new to this group. What are those files need to backup in online backup mode? how we know the database is setup in OPS mode? Please help me. Thanks in advance. Seema _ Get your FREE download of MSN Explorer at

RE: Bad Cookies with Internet Application Server 1.0

The authentication is via the users' oracle passwords. One user just got the error, and she doesn't use cookies. It is intermittent, but once it occurs, the users need to be reauthenticated before it works successfully. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED]

Update existing rows at import

Hi! Is there a tool available that allows me to read data from a comma-delimited flat file into Oracle and if a row already exists, updates that record. If the row does not exist, it should insert a new record into the table. Looks to me like SQL*Loader can't do this. How could this be done?

ORA-01031: insufficient privileges

Solaris V2.6 Oracle V8.1.8 Previously I logged in as username "HR" did SQL GRANT SELECT ON EMPHEADER_MASTER TO BCM; Within a PL/SQL package the following lines exits. EXECUTE IMMEDIATE 'TRUNCATE TABLE HR_EMP'; EXECUTE IMMEDIATE 'DROP TABLE HR_EMP'; EXECUTE IMMEDIATE 'CREATE TABLE HR_EMP

storage area networks

Anyone using storage area networks for an Oracle database. Who is the vendor and what is your opinion of the product. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 !DOCTYPE HTML PUBLIC

RE: Update existing rows at import

Helmut, have you thought about using UTL_FILE package? -Original Message- Sent: Wednesday, March 28, 2001 2:37 PM To: Multiple recipients of list ORACLE-L Hi! Is there a tool available that allows me to read data from a comma-delimited flat file into Oracle and if a row already

RE: . . .Compaq Tru64 5.1 Cluster / SAN?

Mike, We are using the SAN architecture. Jay [EMAIL PROTECTED] 03/28/01 10:36AM Thanks for the heads up. We are also planning upgrades from 40F to 5.1 nonclustered with Oracle 8.0.6. Has anyone considered or implemented Compaq's SAN architecture? Mike Hand Polaroid Corp -Original

Db stat change query

Hi gurus Is it necessary to take full backup when we change the database from archivelog mode to noarchivelog mode and vice versa. Thanks -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the

RE: SQLCode in 8i

We're not connecting via ODBC, we're using the native drivers, but yes, we have tried both the 7.3 driver we used to use and both the 8.0 and 8.1 drivers. At 12:12 PM 3/28/01 -0800, you wrote: Regina, did you try using the ODBC driver that you used earlier. -Original Message- Sent:

Re: Update existing rows at import

Can you have a before-insert trigger on your table to do whatever you want and then use conventional sqlldr to load it? winnie "Helmut Daiminger" [EMAIL PROTECTED] on 03/28/2001 12:38:10 PM Please respond to [EMAIL PROTECTED] To: "Oracle DBA List \(Lazy DBA\) \(E-mail\)" [EMAIL

Re: Db stat change query

Yes, it is necessary to take a full backup when you change your database from noarchivelog mode to archivelog mode. Or else you will never have a "base" to perform recovery if it is needed. Winnie "Seema Singh" [EMAIL PROTECTED]@fatcity.com on 03/28/2001 01:25:26 PM Please respond to

RE: Update existing rows at import

Helmut, Use SQLLOADER to load the file into a temporary table. Then write a script/procedure to scan the contents of temporary table, compare this info with base table, if row exists, update, else insert. IMME (In my modest eperience) this is the easiest way. HTH Some Raj

RE: Db stat change query

Yes. Unless you can risk having a time where you can't recover your database. Michael Armstead Database Administrator, OCP-Certified Corporate Finance Information Systems Glaxo SmithKline -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March

Re: online backup query

In V$INSTANCE, there is a column named PARALLEL which will tell you whether the instance is in OPS mode or not. In online backup mode, you will need to backup 1) all datafiles 2) a binary backup of the controlfile 3) all archivelog files generated during the online backup period of time 4) I

Re: Update existing rows at import

You can't query or modify the same table as the trigger is firing on (The old mutating table problem). What you could do is set up a temp table with a before insert trigger which would query the other table and take the appropriate actions, this would solve you having to run a separate

Script to Compare table structures

Hi, I would appreciate if someone could pass me a script which compares table structures? Johnson __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L

FW: Standard vs Enterprise Edition

Oops !!! forgot to send the attachment. Jeff, We have a retail application (JDA) using Oracle 8.1.6 using the Standard Edition. It works fine with very few problems. Size of the database is 70GB. The application uses very limited database features. No replication, partitioning, OPS,

Re: Script to Compare table structures

Download free version of TOAD from www.toadsoft.com. Once installed and logged into look under View---Schema Differences you can compare many aspects of two schemas (eg compare your test and production schemas). Table comparisons are one of the many things you can compare. HTH --- Johnson

Does anyone know a link to 9i documentation?

Thanks, Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Standard vs Enterprise Edition

Jeff, We have a retail application (JDA) using Oracle 8.1.6 using the Standard Edition. It works fine with very few problems. The application uses very limited database features. No replication, partitioning, OPS, standby database, ... Please see attached document from Oracle Technet for

RE: Standard vs Enterprise Edition

Title: RE: Standard vs Enterprise Edition Thanks everyone for the replies. -Original Message- From: Suhen Pather [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 6:26 PM To: Multiple recipients of list ORACLE-L Subject: FW: Standard vs Enterprise Edition Oops !!!

NOT A SINGLE MAIL!

Hi! I haven't received a single mail from the LiST.. Is there a problem? Please tell Thanks - Original Message -- "Rachel Carmichael" [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:"Rachel Carmichael" [EMAIL PROTECTED]

Oracle Books on Audio Tapes

Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Apps Sol INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California--

Re: Standard vs Enterprise Edition

The cost of the Enterprise Edition compared to the Standard Edition is large (2 x). The way i figure enterprise is over 6.5 times more expensive. Enterprise = $100/Universal Power Unit to $15.00/Universal Power Unit. That is quite a difference.I would sure make sure we used feature

Nologging

I know it is possible when creating a table to specify no logging so that it doesn't generate redo logs. Is it possible, AFTER the table has already been created, to change it to nologging? Also this is a dev database that we don't care about doing any type of recovery and just want to do some

Re: Nologging

that has nothing to do with the question. But anyway, try ALTER TABLE NOLOGGING instead. oli [EMAIL PROTECTED] wrote Alter database noarchivelog; will change the entire database. see the following for detailed information: http://technet.oracle.com/docs/products/oracle8i/doc_index.htm

about ops on linux

RE: NOT A SINGLE MAIL!

cos u dont like Air. Ask Jared :) -Original Message- From: Cyril Thankappan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 6:16 PM To: Multiple recipients of list ORACLE-L Subject: NOT A SINGLE MAIL! Hi! I haven't received a single mail from the LiST.. Is

Re: Nologging

Yes you can issue the alter table nologging but it will only be relevant for certain operations not all UPDATE, DELETE, conventional path INSERT statements. Jim Reference the following I found on metalink: Doc ID: Note:1038660.6 Type: PROBLEM Status: PUBLISHED Content Type: TEXT/PLAIN

RE: A Basic PL/SQL Question

Hi ... you can go for UTL FILE feature of Oracle PL/SQL, it is very handy while handling large amount of data that DBMS_OUTPUT can't handle due to the buffer size constraints. Cheers, Bagchi. On Wed, 28 March 2001, "Miller, Jay" wrote: Another option is to create a table with a large

RE: Oracle Books on Audio Tapes

Long drive to work ..eh ?? -Original Message- From: Apps Sol [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 6:21 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Books on Audio Tapes Is there any place where we can get Oracle books on Tape (Audio

RE: Re:RE: very urgent

Ajay's going to try that one too, and we are going to get 5 more mails ! :)) -- From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 4:27 AM To: Ajay Jain; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Re:RE: very urgent

identify which logs are need to start recovery

usually i keep 2-3 previous archived logs, after switching and starting the hotbackup... but is there a v$ view to show which logs are needed to start the recovery ? TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City

Re: Source Code about Java Classes

Sergio, It doesn't seem to likely that Oracle will provide the source for their products. Jraed Who is this guy? Can't even spell his own name... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services--

RE: Does anyone know a link to 9i documentation?

Have you not tried at OTN, if it is 9i OAS then try http://technet.oracle.com/docs/products/forms/doc_index.htm HTH! Aleem -Original Message- Sent: Thursday, March 29, 2001 4:35 AM To: Multiple recipients of list ORACLE-L Subject:Does anyone know a link to 9i

  1   2   >