RE: storedProc question

Sameer, What op system are you running with? There is a utility that was posted a few days ago by me that allows you to run any os command from pl/sql as well as sqlplus. I'll try and find the original email I sent out. Cheers, Kev. my computer beat me at chess but i won when it came to kick

Re: White paper on Partitioning

Sona wrote: Hi Is there a white paper on benchmarking done by Oracle on Partitioning? TIA There is a study done for a big Oracle customer by a consultant in the library section of the oriole site (http://www.oriole.com). It dates back to a couple of years (8.0.3/8.0.5) but by and large I

Re: Job queuing!!!

Ayyappan S wrote: Hi all Let me know how to Queue a job. when ever a message is received from a system then the process (procedure) has to start. let me know the steps to follow . with an example. Regards Ayyappan.S RTF $ORACLE_HOME/rdbms/admin/dbmsjob.sql -- Regards, Stephane

Urgent : How to insert/retrieve BLOB ??

hello everybody , i am on 8.1.6 / NT . i have a table named images . it's structure is clip_id int not null, clip_image blob , clip_loc varchar2(100) i need to insert /update / retrieve a image (GIF/JPEG/TIFF) to/from this table. i went thro' the DOCS also . but i don't find any

Oracle cheats UNIX vendors ?

http://www.computerworld.com/storyba/0,4125,NAV47_STO67867,00.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: Selective object export

Or take a look in the catexp script and find a view called something like expvew or whatever, , save the original catexp script, change it to our needs, run the modified catexp script, do your export(s), then run the original catexp script. They are after all just views, so there are no

Unix shell scripting - cool link

For those who already don't know, go to the site listed bellow. http://www.injunea.demon.co.uk/index.htm Great tutorial that deals with shell scripting.

Re: Urgent : How to insert/retrieve BLOB ??

- Original Message - i need to insert /update / retrieve a image (GIF/JPEG/TIFF) to/from this table. i went thro' the DOCS also . but i don't find any example to do this . can anyone help me to do this ? any sample scripts please ? please refer to chapter 9 Internal Persistent

Re: EOUG

It's up and running as from yesterday or so. Looks nice, and a lot of events are scheduled. Mogens Karniotis, Stephen wrote: I believe EOUG is co-hosting the Oracle Open World in Copenhagen this year. Here is a letter from their web site, www.eoug.com Dear Oracle User The EOUG is being

RE: HOW TO KNOW INDEX NOT IN USE?

Same with me - but one thing we did have to do was move the outline tables to their own tspace (good practice anyway I suppose) and bump up the freelists since we got some contention when things got busy. hth connor --- Larry Elkins [EMAIL PROTECTED] wrote: Tony is thinking along the same

Production Oracle DBA Needed in Rochester, Minnesota

Position: Oracle DBA Location: Rochester, Minnesota Salary Range: 65-75K- maybe more Description: This client company-a leader in its' field, needs an Oracle DBA to provide database support. This position includes support of all aspects of the Oracle relational database product (ASE) on

Re: compressing rman backups through pipes

The problem is that I don't have enough room on disk to do the backups off peak. I will be getting another disk (18 or 36gig ) soon but I was looking for a way to hold us in the meantime. Thanks! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent:

Re: storedProc question

Sameer, Read Oracle manuals on external stored procedures. From external stored procedures you can execute OS commands. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 06, 2002 3:20 AM

Select DISTINCT question

Title: Select DISTINCT question Hi everyone, Is one of these more correct than the other ? 1) select distinct customer_number, address_code from orders; 2) select customer_number, address_code from orders group by customer_number,address_code; Our developers do the 1st one

UPgrade or Reinstall ?

Hi everyone - I have recently installed an instance of Oracle, version 8.1.7 on a Sun Solaris machine (running 2.6). I have the base instance completed, and am waiting for the clients to finalize their design. Now, after discussing it, we've decided we should try to implement on 9i instead.

User Forums for MS SQL Server

Title: User Forums for MS SQL Server All, Are there any email list groups for MS SQL Server similar to ORACLE-L ? Thanks, Rama Ari Database Administrator [EMAIL PROTECTED] 610.964.5128

Problem Running SQL Script

I am working through the book "OCP Intro to Oracle9i; SQL Exam Guide" by Jason Couchman. On page 6 they say to run the script utlsampl.sql to create objects. So, I have run it from the Command Prompt, SQL*Plus and the SQLPlus Worksheet with the same problem. I have checked Oracle Press

Duplicate rows

Hi gurus, I need detect and delete duplicate rows in any table, somebody helpme thanks!!! @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de

Re: Select DISTINCT question

IMHO since they both require Oracle to sort the table and you are doing a full table scan in both cases the performance would be virtually the same. Rick

Re: Select DISTINCT question

Beth, Without going into very much detail about the two selects. 1 will return only the records that are distinct from each other and 2 will return all rows in a particular order. Using 1 could result in the elimination of records if there is more than one record that meets the distinct

Re: Problem Running SQL Script

KENNETH JANUSZ wrote: I am working through the book OCP Intro to Oracle9i; SQL Exam Guide by Jason Couchman. On page 6 they say to run the script utlsampl.sql to create objects. So, I have run it from the Command Prompt, SQL*Plus and the SQLPlus Worksheet with the same problem. I have

Re: User Forums for MS SQL Server

Rama, Go to http://www.swynk.com/faq/sql/sqlserverfaq.asp to join and go to http://www.swynk.com/sqllinks.asp for other sqlserver links HTH Rick

Latest patch for 8.1.7.0.0 (Win2k)

Hi, everyone, Couldn't find anything on Metastink. Could someone forgive my dumbness and help? TIA, Best, Sergey -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Re: Select DISTINCT question

Seefelt, Beth wrote: Hi everyone, Is one of these more correct than the other ? 1) select distinct customer_number, address_code from orders; 2) select customer_number, address_code from orders group by customer_number,address_code; Our developers

RE: User Forums for MS SQL Server

Title: User Forums for MS SQL Server Rama, Here is a link that will get you to a good SQL Server list http://ls.swynk.com/scripts/lyris.pl -Original Message-From: Ari, Rama [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 06, 2002 9:24 AMTo: Multiple recipients of list

Re: User Forums for MS SQL Server

Title: User Forums for MS SQL Server http://www.swynk.com/discuss_home/ Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Ari, Rama To: Multiple recipients of list ORACLE-L Sent: Wednesday, February 06, 2002 10:23 AM Subject: User Forums for MS

Re: Select DISTINCT question

The second one does not make sense. Group by is normally used when you are including a function that would return a single value (like sum or count) and yet want to have more than one row returned because you are including a column that is not within the function so 1 is definitely more correct

Re: UPgrade or Reinstall ?

YTTRI Lisa wrote: Hi everyone - I have recently installed an instance of Oracle, version 8.1.7 on a Sun Solaris machine (running 2.6). I have the base instance completed, and am waiting for the clients to finalize their design. Now, after discussing it, we've decided we should try to

RE: UPgrade or Reinstall ?

Lisa, As far as I'm concerned, I would trash your existing instance and start over. The only real reason to perform a migration is to preserve an existing database. In your case, you have nothing except for a vanilla instance which can be re-created easily. On the other hand, if you wish to

Re: UPgrade or Reinstall ?

Since it is new I would start over and install 9i instead of upgrade. Rick YTTRI Lisa

Suns, We don't need no stinkin' Suns

http://www.computerworld.com/storyba/0,4125,NAV47_STO67867,00.html === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET:

Re: Problem Running SQL Script

Without seeing the script I would guess one of two things. 1) Trying to connect to a non-existant user. 2) It actually worked and script suppresses output to terminal. I would open up the script and look to see what it is doing. Perhaps put spool command if it does not have one. Rick

RE: Duplicate rows

Alex, Here are a couple of scripts that have come from the list in the past: === declare cursor get_dups is select pk_col1, pk_col2, pk_col3, count(*) from table group by pk_col1, pk_col2, pk_col3 having count(*) 1; dupRec get_dups%rowtype; begin for

Re: Problem Running SQL Script

KENNETH JANUSZ wrote: SQL @c:\oracle\ora90\rdbms\admin\utlsampl.sql; Disconnected from Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option JServer Release 9.0.1.1.1 - Production Any ideas as to what the problem is? problem is EXIT T. -- Please see

RE: User Forums for MS SQL Server

Title: User Forums for MS SQL Server http://www.openitx.com/ they have several small db mail lists. light traffic for an email list. Jon Baker Database Architect [EMAIL PROTECTED] www.netsec.net -Original Message-From: Ari, Rama [mailto:[EMAIL PROTECTED]]Sent: Wednesday,

Re: Duplicate rows

Here is a query that was posted here a while ago: delete from pa_answer where rowid in (select rowid from p_answer pa where rowid (select min(pa2.rowid) from p_answer pa2 where pa.p_id = pa2.p_id and pa.p_name = pa2.p_name)) This should help. Viktor --- Alexander Ordonez [EMAIL PROTECTED]

RMAN Incremental backups.

Hi All, I am new to RMAN. I am reading RMAN documentation and doing some testing on our development box. I have couple of questions. 1. Our database is in NOARCHIVE LOG mode and I would like to do Incremental backups. Since db is in noarchive log mode, I put the database in mount

RE: Problem Running SQL Script

Why do you think there is a problem? May be it finishes and disconnects successfully. -Original Message-From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 06, 2002 10:33 AMTo: Multiple recipients of list ORACLE-LSubject: Problem Running SQL Script I

OT Now - was RE: screen

Well, concurrently could be difficult, but consecutively The use of screen allows more time for sex and skiing, after which I have to sleep and eat sushi to recover my energy :) Robert and Rachel (RR) wrote: I was just hoping it was really a list. If they were concurrent we might

RE: Duplicate rows

Or to just count them: SELECT col1,col2.coln,count(*) from table Group by col1,col2...coln Having count(*) 1; -Original Message- Sent: Wednesday, February 06, 2002 10:33 AM To: Multiple recipients of list ORACLE-L Subject:Duplicate rows Hi gurus, I need detect and

Re: User Forums for MS SQL Server

Title: User Forums for MS SQL Server Are there any email list groups for MS SQL Server similar to "ORACLE-L" ? try this link: http://searchdatabase.techtarget.com/bestWebLinks/0,289521,sid13_tax282897,00.html and also the microsoft.public.sqlserver.* groups from

Re: Select DISTINCT question

Ron, What am I missing? Both selects will ALWAYS return the same data. Correct??? Rick Ron Rogers

Re: Problem Running SQL Script

have you tried actually LOOKING at the sql script itself to see what is happening? I mean, you are studying for the SQL exam, what better way to study than to figure out what is going wrong in a SQL script? --- KENNETH JANUSZ [EMAIL PROTECTED] wrote: I am working through the book OCP Intro to

Re: Problem Running SQL Script

Ken, Why don't you look inside the utlsampl.sql file, and see what's going on? Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: KENNETH JANUSZ To: Multiple recipients of list ORACLE-L Sent: Wednesday, February 06, 2002 10:33 AM Subject:

RE: TABLESPACE PCTINCREASE?

The biggest problem with setting the PCTINCREASE to 0 on existing tablespaces is that it won't automatically coalesce. You may need to manually coalesce occasionally especially if you deallocate tables or rebuild indexes. Below is what I use to see tablespaces needing coalescing: select

RE: Problem Running SQL Script

That script sets TERMOUT off and has an 'exit' at the end Pl check if it has created those sample objects in SCOTT schema.. - Kirti -Original Message-From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 06, 2002 9:33 AMTo: Multiple recipients of list

RE: Suns, We don't need no stinkin' Suns

There was a thread re. this a couple of days ago. Basically, because Oracle will run its apps suite on LINUX doesn't mean it is jettisoning SUN altogether - In my opinion they just want to be more competitive than other apps suite vendors, one way to do that is to reduce OS and hardware costs.

RE: Problem Running SQL Script

Simple The last command is EXIT, so you disconnect and exit. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: KENNETH JANUSZ [SMTP:[EMAIL PROTECTED]] Sent: Wed, February 06, 2002 5:33 PM To: Multiple recipients of list ORACLE-L Subject:

Re:RE: UPgrade or Reinstall ?

Lisa, I wil agree with Tom, unless this is a dry run for a real database that you have to migrate. In that case I would migrate this test area just for the experience. Dick Goulet Reply Separator Author: Mercadante; Thomas F [EMAIL PROTECTED] Date:

Re: Duplicate rows

Courtesy of Ari Kaplan of this list: delete from table_name a where rowid (select min(rowid) from table_name b where a.column_name=b.column_name ) / this works if only one column is duplicated but you should be able to change it (concatenate all the columns together?) if you don't duplicate

oraInventory

Hi - Can anyone tell me if the oraInventory directory concept is still used with versions 8i and 9i? If so, I have a question. We have an installation of Oracle Express that contains the oraInventory directory (since it was installed long before Oracle on this server). They are now planning

Re: Duplicate rows

Alexander Ordonez wrote: Hi gurus, I need detect and delete duplicate rows in any table, somebody helpme thanks!!! @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de

RE: Duplicate rows

thanks for your help!!! @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática Telefono: 295-2004, San José, Costa

Re: Duplicate rows

DELETE FROM table a WHERE a.rowid (SELECT MIN(b.rowid) FROM table b WHERE b.key_field1 = a.keyfield1 AND b.key_field2 = a.keyfield2 AND

RE: Select DISTINCT question

I think Ron is talking about ORDER BY instead of GROUP BY ... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 11:08 AM To: Multiple recipients of list ORACLE-L Subject: Re: Select DISTINCT question Ron, What am I

RE: Duplicate rows

thanks!!! @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática Telefono: 295-2004, San José, Costa Rica

Re: Duplicate rows

delete from z where rowid in (select rowid from z a where a.rowid (select min(rowid) from z b where a.x = b.x)); Alexander Ordonez wrote: Hi gurus, I need detect and delete duplicate rows in any table, somebody helpme thanks!!! @lex

Remote Compromise in Oracle 8i/9i Database Server

Take a look at this... -Original Message- Sent: Tuesday, February 05, 2002 11:34 PM To: [EMAIL PROTECTED] NGSSoftware Insight Security Research Advisory Name:Oracle Remote Compromise Systems Affected: Oracle 9, 8 Platforms: All Operating Systems Severity: High Risk Vendor URL:

RE: Duplicate rows

Delete from table_name where rowid not in(select min(rowid) from table_name group by col1,col2,...coln); Best, Sergey -Original Message- Sent: Wednesday, February 06, 2002 10:33 AM To: Multiple recipients of list ORACLE-L Subject:Duplicate rows Hi gurus, I need detect and

Re: Problem Running SQL Script

Ken, Take a look at the top of the script: SET TERMOUT OFF SET ECHO OFF Those 2 lines ensure that you won't see any output. At the end of the script: EXIT. If you didn't see any error messages, it all worked as it should. Jared KENNETH JANUSZ [EMAIL PROTECTED] Sent by: [EMAIL

RE: Latest patch for 8.1.7.0.0 (Win2k)

Go to ftp://oracle-ftp.oracle.com/server/patchsets/NT and you should be able to find it there. -::YEX::- ))) -Original Message- Sent: Wednesday, February 06, 2002 10:44 AM To: Multiple recipients of list ORACLE-L Hi, everyone, Couldn't find anything on Metastink. Could someone

RE: TABLESPACE PCTINCREASE?

Jerry, Manual coalescing should not be necessary. Rather than reformat the manual to be legible in an email, I'll provide link to the section on allocating extents: http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a88856/c03block.htm#2846 Jared Whittle Jerome Contr NCI

RE: Duplicate rows

Title: RE: Duplicate rows Delete duplicate records Sanjay Raj 06 Dec 2001, Rating 4.42 (out of 5) Here is a short Oracle script that deletes duplicate records from a table based on the unique columns selected: Rem del_dup.sql Rem Rem Script to delete duplicate rows from a table Rem Rem

RE: RMAN Incremental backups.

Prasad, Incremental backups are only valid if your database is in ARCHIVELOG mode. Think about it - to be able to recover using incremental backups, you *Need* the archivelog files to apply changes. These are not being created when you are running in NOARCHIVELOG mode. Secondly, flipping

Ora

Hello All I got the following error: ORA-03232: unable to allocate an extent of 127 blocks from tablespace 3 How can I know what tablespace is '3'? ora816 on nt. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Unorthodox 8i install/upgrade

Environment: Tru64 V5.1 on Alpha 4100/8100 ORA 8.0.6 I have upgraded our sandbox system to 8.1.7.2 last month, and will be upgrading several other machines shortly. The problem is the stage ORACLE_HOME mount points have insufficient disk space and our systems folks have told me that it

Re: Duplicate rows

Hi, Probably the best way is to attempt to enable a unique constraint and use the exceptions table to find the rowid's all rows that violate the constraint. John [EMAIL PROTECTED] wrote: Hi gurus, I need detect and delete duplicate rows in any table, somebody helpme thanks!!! @lex

svrmgrl

Hi, Where can I find svrmgrl in 9i. It is not in the same place as 8i. Thanks -- 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

RE: Data Retrieval Tool

One option is to look into Oracle's Migration Workbench. It's a free download from Technet (technet.oracle.com). It can take an existing Access datrabase, create the same tables in an Oracle schema, move the data to the Oracle tables, and so on. I've used it and it works well. One option it

Re: Select DISTINCT question

-- Please see the official ORACLE-L FAQ: htt p://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

RE: User Forums for MS SQL Server

http://listserv.swynk.com/scripts/lyris.pl?site=swynk.com http://listserv.swynk.com/scripts/lyris.pl?site=swynk.compage=topictopic= sqlservertext_mode=0lang=english page=topictopic=sqlservertext_mode=0lang=english -Original Message- Sent: Wednesday, February 06, 2002 7:09 AM To: Multiple

Re: Problem Running SQL Script

My apologies -- dumb dumb here forgot to look at the script. It happened so fast that I thought there was a problem with the script. Again my apologies, Dumb Dumb - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 06, 2002 11:23 AM

Re: Ora

select * from v$tablespace; Don Bricker Database Administrator / System Administrator Illinois Environmental Protection Agency 1021 North Grand Avenue East Mail Code #32 Springfield, IL 62794-9276 [EMAIL PROTECTED] (217) 558-2290 [EMAIL PROTECTED] 02/06/02 10:33AM Hello All I got the

RE: Database Performance Question

Srini, If you have 400 concurrent users (2000 total users, with about 400 concurrent sessions typical for the busy time of the day), then you should probably be using MTS instead of dedicated connections. Using Microsoft pooling in COM may work out, but please check with Oracle support on

RE: Ora

select name from sys.ts$ where ts# = 3; -Original Message- Sent: Wednesday, February 06, 2002 11:34 AM To: Multiple recipients of list ORACLE-L Hello All I got the following error: ORA-03232: unable to allocate an extent of 127 blocks from tablespace 3 How can I know what tablespace

Re: RMAN Incremental backups.

the documentation told you: no they are not just because the incremental backup completed does not mean that it is usable. Either leave the database in archivelog mode to do incremental backups or keep it in noarchivelog mode (and why you would not want to do that is a whole other discussion)

RE: Ora

Yechiel, SELECT ts#, name FROM sys.ts$ WHERE ts# = 3; Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Hello All I got the following error: ORA-03232: unable to

Re: svrmgrl

that's because, as Oracle has been promising, they no longer support svrmgrl in 9i. It does not exist, you will need to use sqlplus: sqlplus /nolog connect / as sysdba --- [EMAIL PROTECTED] wrote: Hi, Where can I find svrmgrl in 9i. It is not in the same place as 8i. Thanks -- Please

RE: svrmgrl

srvmgrl no longer exists in 9i. You do everything through sqlplus. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 06, 2002 12:44 PM To: Multiple recipients of list ORACLE-L Subject:svrmgrl Hi, Where can

Oracle Transparent Gateway

Thanks to the people who tipped me off to this product. From the marketing fluff on Technet, it looks like this will do what I want it to do (i.e. extract data from DB2 on O/S390 into Oracle 8.1.x on UNIX). If anyone on the list has actual experience doing this I would be interested in your

RE: svrmgrl

You should use sqlplus instead of svrmgrl now. -Original Message- Sent: Wednesday, February 06, 2002 1:44 PM To: Multiple recipients of list ORACLE-L Hi, Where can I find svrmgrl in 9i. It is not in the same place as 8i. Thanks -- Please see the official ORACLE-L FAQ:

RE: Select DISTINCT question

I think he just misread the group by as an order by -Original Message- Sent: Wednesday, February 06, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Ron, What am I missing? Both selects will ALWAYS return the same data. Correct??? Rick

Re: compressing rman backups through pipes

That is what we have done since our backups have gotten so big that they won't fit on one tape (RS6000/DLT tapedriv e). I limit the size of each file to 2gig. Rman can't really handle files larger than 2 gig, at least 8.0.6.3 can't. I also limit my datafile size to 2 gig so I can backup one

Re: svrmgrl

It no longer exists -- all related functionality has been incorporated into sqlplus. Read the release notes and bulletins. -Joe On Wed, 06 Feb 2002 10:43:34 -0800 [EMAIL PROTECTED] wrote: Hi, Where can I find svrmgrl in 9i. It is not in the same place as 8i. Thanks -- Please see the

RE: Oracle Transparent Gateway

Peter, I used it briefly a couple of years ago. It certainly works well enough. The problem I had related to password administration. When you set it up in Oracle, you need to provide the password to an id on the OS/390 system. Our OS/390 system requires us to change passwords every 30

Re: Duplicate rows

um yeah, that works too :) --- orantdba [EMAIL PROTECTED] wrote: Hi, Probably the best way is to attempt to enable a unique constraint and use the exceptions table to find the rowid's all rows that violate the constraint. John [EMAIL PROTECTED] wrote: Hi gurus, I need detect

RE: Latest patch for 8.1.7.0.0 (Win2k)

Thank you, I will try. Just got a response from Oracle support it was NOT going to be released for a couple of days. Bizarre, so bizarre -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 1:38 PM To: Multiple recipients of list ORACLE-L Subject:

RE: svrmgrl

You will not find it in 9i, because they have taken it away. It doesn't exist starting from 9i. We have to use 'sqlplus' for everything we did using 'svrmgrl'. I suggest you check out the 9i docs at : http://tahiti.oracle.com/ as there are a lot of new features in 9i. - Kirti -Original

database concepts

does anyone know of a web site where I can copy off a writeup on overall database concepts? thanks in advance, roy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ferguson II, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

RE: UPgrade or Reinstall ?

It's unanimous - start over. Thanks everyone. -Original Message- Sent: Wednesday, February 06, 2002 9:44 AM To: Multiple recipients of list ORACLE-L Lisa, As far as I'm concerned, I would trash your existing instance and start over. The only real reason to perform a migration is to

Re: Ora

SELECT NAME FROM V$TABLESPACE WHERE #=3; hth, EYRG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 06, 2002 11:33 AM Hello All I got the following error: ORA-03232: unable to allocate an extent of 127 blocks from tablespace

question on EXPLAIN_PLAN

Hi, guys The problem belows is really make me confused and gave me big trouble, is there someone can give me some hlep? I have two databses, same version(oracle 8.1.6),same O/S(win2000), sameschema structure, different data(but small difference ofsize). and even exactly same

RE: UPgrade or Reinstall ?

Lisa - I agree with Tom (always a good move). The way I would put the question is: do you have a large production database that you think you will have to upgrade at some point if the future? If the answer is yes, then I think you should practice the upgrade now. If the answer is no, then forget

ADI Warning

Friends -- Lately I've been relegated to the deepest recesses of the dark murky depths of Oracle's product line. I see you blithely exchanging DBA mail and look on longingly, pining for the fjords, as it were. But I digress. If you every have to install ADI on a PC, make sure it doesn't have

RE: svrmgrl

Didn't Oracle get rid of SVRMGRL in 9i?? -Original Message- Sent: Wednesday, February 06, 2002 12:44 PM To: Multiple recipients of list ORACLE-L Hi, Where can I find svrmgrl in 9i. It is not in the same place as 8i. Thanks -- Please see the official ORACLE-L FAQ:

Re: Data Retrieval Tool

Dennis Move the tables into Oracle and let the users use Access via odbc ;-) [EMAIL PROTECTED] wrote: Good day all, I have been asked the following question a couple of time by our database users - They have a bunch of small Access databases that they want to port into Oracle. Since most of

STATSPACK impact?

Title: STATSPACK impact? Just curious, but if your shop uses STATSPACK, could you tell me how frequently you run it, particularly in your OLTP databases; and whether you've noticed any performance issues with generating frequent STATSPACK snapshots? Thanks.

Re: STATSPACK impact?

I have run it as frequently as once per hour, often times just 2 or 3 times per day - morning, noon, close of business. I have never seen any performance impact, and I don't believe there will be any unless you change the default level of statistics gathering. -Joe On Wed, 06 Feb 2002

RMAN full backup Vs Incremental level 0

Hi I would like to know what are the advantages /disadvantages of full backups vs. incremental level 0 backups.Which one should bedone if we decide to take backups only once daily? How is the recovery operation going to be affected if we choose either? for e.g if i decided to do incremental

Connecting to 8.1.7.2 with Unicode Character set

We are trying to connect to a new 8.1.7.2 database with Oracle NT 7.3.4 client. We are getting an error that says: ERROR: ORA-03106: fatal two-task communication protocol error We don't want to update the desktop. Can anyone tell me what is wrong? Ron Smith -- Please see the official

  1   2   >