RE: Enterprise Manger

2001-05-11 Thread Reardon, Bruce (CALBBAY)
Hi Bambi, To find out what version of OEM you installed you could open up a NT command prompt and type oemctrl status oms and then cancel out of the box that comes up asking for the OMS login. This works for OEM 2.1 and OEM 2.2, not sure if it works for 2.0.4 and below. 2.1 came with 8.1.6 2.2

Re: comp.oracle.databases.server vs ORACLE-L: deathmatch

2001-05-11 Thread Paul Drake
Eric D. Pierce wrote: As far as the Culture of any Oracle-NT-L, I can see the possible advantage of having some weighty expert personalities involved. The culture, and therefore utility, of an email list community is almost always enhanced when the list is created with a good core group of

Re: Oracle 9i Articles - self tuning, launch delayed to

2001-05-11 Thread Paul Drake
Eric D. Pierce wrote: Summary Self-tuning, self-managing Oracle9i monitors your system to provide high availability, reliability and minimized downtime. Whether you are a hosting service, in-house data center, or IT organization, you can rely on Oracle9i and its system

Re: Data Reporting tools

2001-05-11 Thread David A. Barbour
Dick, Go with Discoverer. As the admin, you can build a subset of the data and push it out to the power users with the data labeled any way you like. You can also give you power users the ability to create their own views if you are so inclined. They accomplish this through the GUI, with no

PL/SQL-procedures

2001-05-11 Thread Roland . Skoldblom
How can I write procedure which runs 3 different subprocedures.? Roland Sköldblom -- 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: What columns are in the Primary Key

2001-05-11 Thread Bunyamin K. Karadeniz
select * from user_cons_columns where constraint_name=(select constraint_name from user_constraints where table_name = '1' and constraint_type='P'); .. Bunyamin .. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 10,

Re: ORA-06553: PLS-707: unsupported construct or internal error [2603]

2001-05-11 Thread zabair ahmed
Thanks to those who replied, the LD_LIBRARY_PATH was set in the profile for oracle, unsetting this did the trick. Zabair _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the

RE: Pl/sql loop assistance

2001-05-11 Thread Steve Adams
Hi Jacques, It is not reliable if there is row migration. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Friday, 11 May 2001 3:07 To: Multiple recipients of list ORACLE-L -Original Message- From: Jared

desc SQL*PLUS

2001-05-11 Thread Sajid Iqbal
Hello DBA's I have recently upgraded from 8.1.6.0 to 8.1.6.3. I seem to be having a weird problem in sql*plus, in that whenever I do a describe on a table it comes up with the following error :- SQL desc emp; ERROR: ORA-03113: end-of-file on communication channel I can run select statements

Ora - 4091 error while trying to insert a record into a table

2001-05-11 Thread Ranganath K
Dear DBA Gurus, I have Table A and Table B whose structures are almost similar except Table B has a date-time field column. Whenever I insert a new record into Table A I want to insert the same record into the Table B along with the date-time stamp at which the new record is inserted

Arkeia Backup software

2001-05-11 Thread Mark Teehan
Does anyone use this? It looks funky and I am interested in any opinions before I try it out. Im trying to get out of the Legato/Veritas vicious circle of Very Expensive and only Moderately Useful backup software. http://www.arkeia.com Regards Mark ERG Group

Re: Updating a table :Using dynamically generated table_Names

2001-05-11 Thread paquette stephane
Use dynamic SQL, it is so simple now that there is execute immediate instead of prepare, execute, bind,... --- Vikas Kawatra [EMAIL PROTECTED] a écrit : can someone tell me a way to select all tables from multiple schemas - and then update records in each of these tables based on a certain

Oracle9i block structures

2001-05-11 Thread Danisment Gazi Unal (Unal Bilisim)
Hi, Do you know if Oracle9i block structures are modified ? thanks in advance... -- Use itrprof SQL Analyzer. It formats SQL_TRACE/Event10046 traces and gives tuning advises. It's web based, no download, no configuration. Just click

Re: Oracle9i block structures

2001-05-11 Thread paquette stephane
I only know that you can have multiple blocksize in a DB. --- Danisment Gazi Unal (Unal Bilisim) [EMAIL PROTECTED] a écrit : Hi, Do you know if Oracle9i block structures are modified ? thanks in advance... -- Use itrprof SQL Analyzer. It formats SQL_TRACE/Event10046 traces and

RE: COLLECTION ITERATOR PICKLER FETCH

2001-05-11 Thread Steve Adams
Hi Scott, Pickling is serializing arbitrary object-oriented data structures. That is, converting them into a byte stream for storage, transmission over a network or iterative navigation as in this case. It is a more complex process than you might imagine. If you want more information, search the

RE: Ora - 4091 error while trying to insert a record into a table - RESOLVED

2001-05-11 Thread Ranganath K
Hi Gurus, I got the solution. Here is the modified code: create or replace trigger trig_dept1 after insert on dept for each row begin insert into dept1(deptno, dname, loc, date_time) values(:new.deptno, :new.dname, :new.loc, sysdate); end; Thanks Rob Fegan and Amol Joshi

RE: RMAN Question

2001-05-11 Thread holders
Are the tables you are loading in direct mode in the same tablespace as your other tables ? If this is the case, then you will not be able to perform a complete recovery on the tablespace affecting the other logged tables. Whenever I have a mix like you have, some logged and some not, I keep the

RE: Order of columns in a table

2001-05-11 Thread Mark Leith
LOL!! -Original Message- Pierce Sent: Thursday, May 10, 2001 10:17 To: Multiple recipients of list ORACLE-L HELP On 10 May 2001, at 12:53, SuzyV scribbled with alacrity and cogency: Am I an idiot?? ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Password with special character

2001-05-11 Thread Sinardy Xing
Hi all, Can Oracle User change their password with special characters? Thank you very much Sinady -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

import from corrupted export file.

2001-05-11 Thread Mohit Goyal
hi all, how to take an import from a corrupted export file. the error message is abnormal end of expoort file. Thanks, Mohit -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohit Goyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

RE: Silver vs. Gold support

2001-05-11 Thread Hallas, John
FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails using the old format will continue to be delivered until 30th June 2001. I have worked on 3 sites with Gold

Re: import from corrupted export file.

2001-05-11 Thread Danisment Gazi Unal (Unal Bilisim)
Hi, first of all, be sure that export file is not copied in ASCII mode. if so, You can do: - take a look at import log. find where it's cancelled - I guess internal data structers in export file is not so big. It's so likely that corruption occured on your data. modify binary export file by

RE:PICKLER FETCH

2001-05-11 Thread Ron Rogers
A PICKLER FETCH is a fetch that is issued against a table. But before it actually takes place and anything is returned to you it must be: cleansed of any impurities, placed in a dark mysterious place, covered with an un-named substance that makes it feel crunchy when retrieved, allowed to age

Drop schema and all related objects

2001-05-11 Thread Mujeeb Chowdhry
Hi DBA's, How can I drop schema (user and all it's objects). I have one main user in the application and wants to drop user and all related objects. Can anyone help me in this regard. Thanks Mujeeb Chowdhry Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Re: Drop schema and all related objects

2001-05-11 Thread james ellis
connect as sys or system. drop user username cascade; The user and all objects will be removed. james --- Mujeeb Chowdhry [EMAIL PROTECTED] wrote: Hi DBA's, How can I drop schema (user and all it's objects). I have one main user in the application and wants to drop user and all related

RE: Which tables are in buffer cache.?

2001-05-11 Thread Hillman, Alex
Mark, how do you manually remove objects from buffer cache? I saw you writing before that you know how to do it and I would be very interested to know also if it is not trade secret of course. Alex Hillman -Original Message- Sent: Friday, May 04, 2001 11:11 PM To: Multiple recipients of

RE: Password with special character

2001-05-11 Thread Sinardy Xing
Hi Thye Hock Gan, Thank you for your info. I am using Oracle 8.1.6 Solaris 7 Install patch bug122 for SQL*PLUS How can I change user password with special character alter user teddy identified by bear12#$; is not working because of alter user teddy identified by

File open event

2001-05-11 Thread ARUN K C
Can Somebody please explain to me what this event is , I am not able to find good documentation on this issue. EVENT TOTAL_WAIT TOTAL_TIME TIME_WAITE AVERAGE_WA -- -- -- file identify38343 0 3135 .08176199 file open

Contigency plan

2001-05-11 Thread Sinardy Xing
Hi all, Do you guys have any good references (books or URLs) that teach some good Oracle potential problems with solutions for my contingency plan? Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat

RE: RE: Silver vs. Gold support

2001-05-11 Thread Rachel Carmichael
so the support bill we just paid should get refunded because it was for Silver Support which no longer exists? and I pay for support but they desupport the products I have paid support for, and instead of giving me the new software release so that the support I paid for is still relevant, they

Impact of query tuning

2001-05-11 Thread Boivin, Patrice J
I just thought I should advertise this... usually people just complain. Hi Patrice, I have added indexes on the foreign keys in the [schema_name] tables. Also, I tuned the SQL statements I was using to perform the desired deletes. Results: The one delete job that ran for

XA Transaction Support - How to check for?

2001-05-11 Thread Miller, Jay
I just got the following question from a Microsoft consultant who's helping another department resolve some problems: Is Oracle XA Transaction Support enabled on the Oracle DB?' I have no idea how to check this. If asked, I would have guessed that it was automatically enabled, but this isn't an

Re: Drop schema and all related objects

2001-05-11 Thread Muthaiah
Hi, Drop user user_name cascade; will drop the user including objects. Hope this helps, Muths At 05:40 AM 5/11/01 -0800, you wrote: Hi DBA's, How can I drop schema (user and all it's objects). I have one main user in the application and wants to drop user and all related objects. Can

Re: Contigency plan

2001-05-11 Thread Paul Drake
http://www.drj.com - disaster recovery journal For those of us who are beyond paranoid ... and would be carrying the tapes to the remote data center. Paul Sinardy Xing wrote: Hi all, Do you guys have any good references (books or URLs) that teach some good Oracle potential problems with

PL/SQL Question

2001-05-11 Thread dmeng
I need to whip out a PL/SQL procedure real quick today and have a quick question for fellow-listers ( since today is Friday, hopefully I don't get RTFMed on this one :) ) The purpose of my procedure is to collect stats from v$session_wait periodically ( every second for example) and pump the data

Re: Drop schema and all related objects

2001-05-11 Thread Scott Canaan
Try drop user username cascade; Mujeeb Chowdhry wrote: Hi DBA's, How can I drop schema (user and all it's objects). I have one main user in the application and wants to drop user and all related objects. Can anyone help me in this regard. Thanks Mujeeb Chowdhry Oracle DBA -- Please

I want to re-install system, how can I backup and recover?

2001-05-11 Thread Robert Chen
hi, Because a hacker hackered our system, I have to re-install the solaris. How can I backup the oracle database? Just backup all the physical files? I am not a back up and recover expert. Please help me... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chen

RE: Drop schema and all related objects

2001-05-11 Thread Armstead, Michael A
DORP USER username CASCADE; Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: Mujeeb Chowdhry [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 9:40 AM To: Multiple recipients of list

RE: Drop schema and all related objects

2001-05-11 Thread Armstead, Michael A
Let's try to spell it correctly this time: DROP USER username CASCADE; Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: Armstead, Michael A Sent: Friday, May 11, 2001 9:24 AM To: '[EMAIL

RE: Drop schema and all related objects

2001-05-11 Thread Jack C. Applewhite
Drop User username Cascade ; Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Chowdhry Sent: Friday, May 11, 2001 8:40 AM To:

Re: Contigency plan

2001-05-11 Thread Thater, William
On Fri, 11 May 2001,Paul Drake scribbled on the wall in glitter crayon: -http://www.drj.com - disaster recovery journal - -For those of us who are beyond paranoid ... and would be carrying the -tapes to the remote data center. - -Paul Never underestimate the bandwidth of a station wagon full of

RE: Veritas Backup Exec, Oracle Agent (Win2000)

2001-05-11 Thread Jack C. Applewhite
Eric, We're using Veritas NetBackup DataCenter (at our colocation facility) for Win2k and it's been pretty good. We had a problem earlier this year that eventually prompted Veritas to issue a patched version of one of the executables. They were very responsive, but it was probably due to the

RE: PL/SQL Question

2001-05-11 Thread Jamadagni, Rajendra
Use dbms_lock.sleep() HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an

Oracle error -20001

2001-05-11 Thread Pat Hildebrand
Has anyone any idea what this means? It is coming up when trying to use a procedure in a PL/SQL package to display a web page. With some negative errors we are able to remove them by reloading all for the application in the OAS manager but not this one. Searching MetaLink I come up with

Re: mod_plsql and PL/SQL pages

2001-05-11 Thread Bill Pribyl
Cyril Thankappan wrote: with the advent of PL/SQL pages is Oracle continuing development of MOD_PLSQL or is MOD_PLSQL merely provided for backward compatibility? At run time, the Oracle server and Oracle's version of Apache use modplsql to process PL/SQL Server Pages, so I'd say

RE: Export question.

2001-05-11 Thread Robertson Lee - lerobe
OK, To answer a couple of questions, I did use compute statistics to get the stats. I did not use compress=y. The table should have been 420Mb according to the avg_row_len*num_rows calculation. The export file came out at 5.7Gb. When I imported it fell over at 1Gb. I set my initial extent to

When to go for ORACLE NAMES Server

2001-05-11 Thread Johnson Poovathummoottil
There is another thread going on about no database on a single server, I have another question to ask. We have nearly 30 databases across Sun and Win 2000 Platforms. We are finding it tedious to keep track of tnsnames.ora. While looking out for a solution we hit at ORACLE Names server. I hear

Alert log

2001-05-11 Thread Raj Gopalan
DBAs My alert.log is clogged with following message.. ARC0: received prod ARC0: Beginning to archive log# 4 seq# 286600 ARC0: Completed archiving log# 4 seq# 286600 ARC0: re-scanning for new log files ARC0: prodding the archiver Fri May 11 16:10:01 2001 ARC1: received prod Fri May 11 16:26:00

RE: PL/SQL Question

2001-05-11 Thread Paul Baumgartel
There is indeed a sleep, in dbms_lock, taking a single argument seconds. -Original Message- Sent: Friday, May 11, 2001 11:20 AM To: Multiple recipients of list ORACLE-L I need to whip out a PL/SQL procedure real quick today and have a quick question for fellow-listers ( since today is

Re: PL/SQL Question

2001-05-11 Thread Jared Still
Dennis, How about dbms_lock.sleep(seconds) ? Jared On Friday 11 May 2001 08:20, [EMAIL PROTECTED] wrote: I need to whip out a PL/SQL procedure real quick today and have a quick question for fellow-listers ( since today is Friday, hopefully I don't get RTFMed on this one :) ) The purpose

saving billions? / fwd: GE Scales Back Amid Struggle To Connect Suppliers

2001-05-11 Thread Eric D. Pierce
fyi (follow up to the thread about Oracle's claims to save billions by converting business practices with internet technology) ---original message follows--- Date sent: Thu, 10 May 2001 02:03:28 -0400 (EDT) TODAY'S NEWS * GE Scales Back Amid Struggle To Connect Suppliers ...

Re: Oracle 9i Articles - self tuning, launch delayed to

2001-05-11 Thread Eric D. Pierce
Paul, Clarification: I didn't write the material, I was just posting an excerpt from an Oracle document. Anyway, I vastly enjoyed your comments. so. I take it that you also found the lack of detail about self tuning to be problematic. :) Presumably we now have a lot to look forward to in

RE: Drop schema and all related objects

2001-05-11 Thread Jacques Kilchoer
Title: RE: Drop schema and all related objects -Original Message- From: james ellis [mailto:[EMAIL PROTECTED]] connect as sys or system. drop user username cascade; The user and all objects will be removed. --- Mujeeb Chowdhry [EMAIL PROTECTED] wrote: How can I drop

RE: RE: Silver vs. Gold support

2001-05-11 Thread Thater, William
On Fri, 11 May 2001,Mohan, Ross scribbled on the wall in glitter crayon: -Is this truly the beloved authoress of Oracle DBA 101 I hear? - -You speak sourly of our Lord in front of his very home? snicker snicker Ross be careful. Remember do not meddle in the affairs of dragons, for you are

RE: PL/SQL Question

2001-05-11 Thread Dasko, Dan
while trunc(sysdate, ss) = 30 loop I think this should do whatever's in the loop every minute on the 30 second point. -Original Message- Sent: Friday, May 11, 2001 11:20 AM To: Multiple recipients of list ORACLE-L I need to whip out a PL/SQL procedure real quick today and have a quick

RE: Contigency plan

2001-05-11 Thread Boivin, Patrice J
LOL! There are enough disasters in the world to support a journal? : ) (I know, I know... it's to plan ahead, just in case. I still think this was funny though. It's Friday, OK?) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des

RE: When to go for ORACLE NAMES Server

2001-05-11 Thread Mohan, Ross
if the tediousness exceeds your perception of the difficulty, do Names. if not, not. In my very limited experience, a truly robust, well-managed Names service is great, but takes some work to set up, test, and document. YMMV || -Original Message- || From: Johnson Poovathummoottil

Re:When to go for ORACLE NAMES Server

2001-05-11 Thread dgoulet
We have 20+ instances this mess called PeopleSoft, so keeping track of TNSNAMES is a real tedious thing to do. Consequently we migrated to Oracle Names have loved it ever since. If your going to get on Onames, use either 7.3.4's version of 8.1.6's. 8.0.x's version has way too many bugs.

Why do I still see index partitions when I dropped the underlying table

2001-05-11 Thread Cherie_Machler
This one's got me stumped. We are on 8.0.4 on Sun Solaris 2.6. I have some locally indexed partitions on a table that's partitioned by time. I dropped the '96 and '95 partitions of the underlying table and I no longer see them. I used the following statements: alter table xx truncate

Re: When to go for ORACLE NAMES Server

2001-05-11 Thread Jared Still
Somewhat of a pain to setup for the first time, for sure. But after you get it implemented, you will never want to go back. One caveat: There is a fair amount of software around that *requires* tnsnames.ora or it won't work. Oracle Forms on unix comes to mind. Yes, Oracle's own software

RE: RE: Silver vs. Gold support

2001-05-11 Thread Boivin, Patrice J
I am confused now, I thought Oracle was rolling up the support costs into the license cost calculations now that they discontinued the Bronze, Silver, Gold support options. This is like income tax forms! Why can't they just create an income tax form that is only half a page long! I can't

Re: PostGres WAS: RE: Oracle 9i Articles - self tuning, launch delaye

2001-05-11 Thread Diana_Duncan
Yes, it's open source. My personal project uses Apache, PHP and Postgres on Linux servers -- pure open source. Guess how long the servers and the web server and hence the site have been up? Pretty much since we installed. Love it!!! For those of you who don't know, PHP is a server-side

RE: RE: Silver vs. Gold support

2001-05-11 Thread Mohan, Ross
Yes, I join you in significant frustration with oracle. ( Although I had a visitation from an OWS goddess just recently that ameliorates my rancor significantly.) Things like Postgres www.postgresql.org and Kdb www.kx.com are becoming increasingly interesting to me. But, even if I

RE: Which tables are in buffer cache.?

2001-05-11 Thread Connor McDonald
I think if you offline a tablespace (or is it read-only? I can't remember), then any relevant buffers are flushed out... hth connor --- Hillman, Alex [EMAIL PROTECTED] wrote: Mark, how do you manually remove objects from buffer cache? I saw you writing before that you know how to do it and I

RE: Password with special character

2001-05-11 Thread Yexley Robert D SSgt AFIT/SCA
If you're using the a profile with a password_verify function, then you shouldn't be using ALTER USER to change a user's password. If you are trying to change the password through SQL*Plus, then you should instead be using the SQL*Plus PASSWORD command: SQL PASSWORD username Using this command

Re: desc SQL*PLUS

2001-05-11 Thread Stephen Andert
We had a similar thing when we upgraded OS last weekend. Re-linking sqlplus from the correct (i.e. new) ORACLE_HOME resolved our problem. HTH Stephen [EMAIL PROTECTED] 05/11/01 01:35AM Hello DBA's I have recently upgraded from 8.1.6.0 to 8.1.6.3. I seem to be having a weird problem in

RE: Drop schema and all related objects

2001-05-11 Thread Hillman, Alex
If there is a lot of objects in the schema you may need to increase parameter enqueue_resources. If not enougn enqueues this command will give you an error and user and some objects will not be dropped. If you don't want to increase this parameter you can repeate this command until user will be

RE: RE: Silver vs. Gold support

2001-05-11 Thread Thater, William
On Fri, 11 May 2001,Mohan, Ross scribbled on the wall in glitter crayon: -question: Are you an idiot? Yes, but everybody already knows that.;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta

Re: PL/SQL-procedures

2001-05-11 Thread David A. Barbour
Write a package. David A. Barbour [EMAIL PROTECTED] wrote: How can I write procedure which runs 3 different subprocedures.? Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

RE: RE: Silver vs. Gold support

2001-05-11 Thread Henry Poras
I was also under the impression that Oracle was just splitting up the cost for Upgrades and Support mainly because these two pieces can be dealt with differently for tax purposes. I have no clue what makes large (or even moderately small) corporations happy, but apparently this is one thing that

Re: PL/SQL Question

2001-05-11 Thread Jared Still
Dan, While this does not work as is, but probably could be in some fashion, you win the days raspberry for the most obfuscated answer. :) Jared On Friday 11 May 2001 09:56, Dasko, Dan wrote: while trunc(sysdate, ss) = 30 loop I think this should do whatever's in the loop every minute on

RMAN compatibility

2001-05-11 Thread mike oneil
Hi, I've installed RMAN 8.1.7 with my db on NT. I also use it to back up another NT cluster instance, also 8.1.7. I also wanted to use it to backup a HPUX 8.1.5 instance but i get an error Target DB is not compatible with version of RMAN. Now I get two answers from Oracle. The first one

Re: RE: Drop schema and all related objects

2001-05-11 Thread Mujeeb Chowdhry
Thanks to all who replied, it works. [EMAIL PROTECTED] 05/11 1:42 PM -Original Message- From: james ellis [mailto:[EMAIL PROTECTED]] connect as sys or system. drop user username cascade; The user and all objects will be removed. --- Mujeeb Chowdhry [EMAIL PROTECTED] wrote:

Re: PL/SQL Question

2001-05-11 Thread Bill Pribyl
[EMAIL PROTECTED] wrote: I am wondering if there is a similar function in PL/SQL similar as the Unix 'sleep' command. Use dbms_lock.sleep -- it's pretty much like Unix sleep, but requires you to grant execute on dbms_lock to whichever account needs it. Bill --

OT - RE: PostGres

2001-05-11 Thread Scott . Shafer
Diana, Sounds like an excellent alternative to higher end systems (shoots self in oracle-foot). Have you tested how well it scales yet? Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 10:27 AM

RE: RE: Silver vs. Gold support

2001-05-11 Thread Mohan, Ross
Is this truly the beloved authoress of Oracle DBA 101 I hear? You speak sourly of our Lord in front of his very home? snicker snicker || -Original Message- || From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 11, 2001 10:21 AM || To: Multiple recipients of list

Re: PL/SQL Question

2001-05-11 Thread Richard Ji
dbms_lock.sleep(second in number); [EMAIL PROTECTED] 05/11/01 11:20AM I need to whip out a PL/SQL procedure real quick today and have a quick question for fellow-listers ( since today is Friday, hopefully I don't get RTFMed on this one :) ) The purpose of my procedure is to collect stats from

RE: Oracle 9i Articles - self tuning, launch delayed to

2001-05-11 Thread sheisey
Eric, Sales and marketing have 1 job and that is to sell and market. These marketing things are teasers not necessarily giving detailed information. I have not checked but there may be some Oracle9i stuff on OLN. I think OLN has a trial membership (for 30 days?). However I am not sure of the

RE: After Update on TABLE_NAME For Each Row... Triggers and

2001-05-11 Thread Henry Poras
I ran a few tests of this on both a 7.3.4 and 8.1.6 database and found there is definitely a difference in the way Oracle handles FK constraints. In my tests, I created a PARENT and CHILD table, with FK constraint, and with a trigger on the CHILD. I used two differenct after update triggers: one

Fwd: oracle replication

2001-05-11 Thread Jared Still
FYI I am forwarding this to the list, so please address replies to the original sender. -- Forwarded Message -- Date: Fri, 11 May 2001 12:45:43 +0530 Hi jared This is Nihar from india. I am having some query regarding Oracle Replication. Basically i am having 2 diffrent

Re: Password with special character

2001-05-11 Thread Bill Pribyl
Sinardy Xing wrote: Hi all, Can Oracle User change their password with special characters? As with other Oracle identifiers, you have to put double quotes around the password to include nonstandard stuff. SQL ALTER USER SCOTT IDENTIFIED BY *^%$$# L; User altered. SQL CONNECT scott/*^%$$#

RE: PostGres WAS: RE: Oracle 9i Articles - self tuning, launch

2001-05-11 Thread Mohan, Ross
Love it! It's open to change.how cool. || -Original Message- || From: Gary Boyd [mailto:[EMAIL PROTECTED]] || Sent: Thursday, May 10, 2001 9:16 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: PostGres WAS: RE: Oracle 9i Articles - self || tuning, launch || ||

Re:Oracle error -20001

2001-05-11 Thread dgoulet
Pat, I could be totally off base here, but I believe that errors in the -2 to -20100 range are user defined via the RAISE_APPLICATION_ERROR procedure. That being the case you may not be able to find the error unless you have the source code. Dick Goulet Reply

Re: Contigency plan

2001-05-11 Thread Rachel Carmichael
For those of us who are beyond paranoid ... and would be carrying the tapes to the remote data center. HEY! I resemble that remark! Rachel From: Paul Drake [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Contigency plan

RE: When to go for ORACLE NAMES Server

2001-05-11 Thread Jesse, Rich
Too much of a kill? Not at all. We are currently running ONAMES, and are planning on going OID as soon as we can get some time. OID (Oracle's LDAP) has other benefits like being able to authenticate more than just Oracle connections. ONAMES is relatively easy to setup. For your

AW: PL/SQL Question

2001-05-11 Thread Haunschmidt Andreas VASL/FAS
Hi: use the procedure: dbms_lock.sleep(seconds); HTH -- Von: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]] Gesendet: Freitag, 11. Mai 2001 17:20 An: Multiple recipients of list ORACLE-L Betreff: PL/SQL Question I need to whip out a PL/SQL procedure real quick today

RE: When to go for ORACLE NAMES Server

2001-05-11 Thread Adams, Matthew (GEA, 088130)
Title: RE: When to go for ORACLE NAMES Server There is one thing to be aware of. In a very large environment, (which you may or may not have) you don't always want everyone to be able to connect to everywhere. By using tnsnames.ora files, we can control which clients are allowed to connect

Re: PL/SQL Question

2001-05-11 Thread Karthik Ramachandran
Try DBMS_LOCK.SLEEP ( seconds IN NUMBER); Regards Karthik Ramachandran [EMAIL PROTECTED] 05/11/01 11:20AM I need to whip out a PL/SQL procedure real quick today and have a quick question for fellow-listers ( since today is Friday, hopefully I don't get RTFMed on this one :) ) The

RE: When to go for ORACLE NAMES Server

2001-05-11 Thread Mohan, Ross
Jared, You may have just earned yourself a dinner. (And I promise you will not receive it the way you did my $0.02 recently ;-) Can you tell me more...alot more would be grand...about how Forms needs tnsnames? *thanks* Ross || -Original Message- || From: Jared Still

RE: When to go for ORACLE NAMES Server

2001-05-11 Thread Jacques Kilchoer
Title: RE: When to go for ORACLE NAMES Server -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] We have 20+ instances this mess called PeopleSoft, so keeping track of TNSNAMES is a real tedious thing to do. Consequently we migrated to Oracle Names have

Re: 9i Real Application Clusters

2001-05-11 Thread sheisey
Rajnedra, Oracle9i RAC is what we now call Oracle Parallel Server. Oracle9i RAC is still BETA, so there may not be any white papers at the moment. I have looked and have not found any white papers on RAC. Scott Dear Friends Does anyone have any knowledge or experience with Oracle 9i

Re: Alert log

2001-05-11 Thread Mohammad Rafiq
Your archiving is TRUE instead of false Check for log_archive_start FALSE change this parameter to false and rebounce your database. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 11 May 2001 08:46:06 -0800 DBAs

Re: PL/SQL Question

2001-05-11 Thread Riyaj_Shamsudeen
dbms_lock.sleep will do this... Thanks Riyaj Re-yas Shamsudeen Certified Oracle DBA i2 technologies www.i2.com [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/11/01 10:20 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:

RE: RE: Silver vs. Gold support

2001-05-11 Thread Thater, William
On Fri, 11 May 2001,Boivin, Patrice J scribbled on the wall in glitter crayon: -Likewise with Oracle, and other vendors - why complicate things needlessly? -Life is bad enough as it is, why try to mess things up for other people even -more. Because they can? -- Bill Thater

Re: Why do I still see index partitions when I dropped the

2001-05-11 Thread Ron Rogers
Cherie, I take it that you built your indexes as create index xxx on table(col) local (partition x1 on tablespace 95, partition x2 on tablespace 96..) then you truncated the table in the partition 95 and then dropped the partition. If I remember correctly the index for the dropped partition

RE: import from corrupted export file.

2001-05-11 Thread Scott . Shafer
ftp the file to the server again in binary mode instead of ascii... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Mohit Goyal [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 6:55 AM To: Multiple recipients of list ORACLE-L Subject: import from

Re: Oracle9i block structures

2001-05-11 Thread sheisey
Unal, What part of the block sturcture? Segment Header, Datablock Header? There are things in the blocks that are no different than they where in 6,7,8 or 8i. However with some of the new features such bitmap freelists, low highwater mark, high high waterwater, and changes to pctfree. There

Re: I want to re-install system, how can I backup and recover?

2001-05-11 Thread Rachel Carmichael
well if you are lucky and all the files are there, yes, backup the physical datafiles and when you bring the database up again, Oracle will recover. You MAY have to open the database resetlogs. Questions though: is the database still up? Can you shut it down cleanly (shutdown) and then do a

Can I partition my primary key constraint index?

2001-05-11 Thread Cherie_Machler
Oracle will automatically create an index for your primary key constraint. I have a lot of large partitioned tables in my data warehouse. All of my primary key indexes are non-partitioned. I would like them to be partitioned. When I drop the constraint and re-enable it, can I specify at that

RE: Password with special character

2001-05-11 Thread Jacques Kilchoer
Title: RE: Password with special character -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] I am using Oracle 8.1.6 Solaris 7 Install patch bug122 for SQL*PLUS How can I change user password with special character alter user teddy identified by

  1   2   >