RE: how to schedule an execution in PL/SQL

2002-08-20 Thread Atul Kumar Srivastav
may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Atul Kumar Srivastav INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Avoding Mutation of Table trigger

2002-08-20 Thread Atul Kumar Srivastav
of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Atul

SCO UNIX

2002-08-19 Thread Atul Kumar Srivastav
Hi everybody, Could anybody tell which is the latest version of SCO UNIX. and does Orale 8i DB works on that. Any info of Oracle on SCO unix. Thanx in advance, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Atul Kumar Srivastav INET: [EMAIL PROTECTED] Fat City

RE: rbs oracle data block corrupted

2002-06-30 Thread Atul Kumar Srivastav
are the all error messages ? regards... Atul Kumar Srivastav wrote: Hi All ! We have one problem. We can mount the database but not able to open it. It gives following error while opening: One Oracle Data Block Corrupted. RBS01.dbf (datafile for rollback segment) How

oracle installation problem

2002-06-28 Thread Atul Kumar Srivastav
. :change_on_install system account password :manager Also listener.ora file not genereted(empty) Please suggest solution. It is urgent. Atul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Atul Kumar Srivastav INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Drop Database Link

2002-04-24 Thread Atul Kumar
this database link? Note that while executing this SQL i was connected with the owner and this database link is private database link. Thanks in advance Atul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Atul Kumar INET: [EMAIL PROTECTED] Fat City Network Services

Materialized View

2002-04-24 Thread Atul Kumar
: at SYS.DBMS_SNAPSHOT_UTL, line 845 ORA-06512: at line 1 Why such error is coming and how can i create materialized view? Thanks in advance Atul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Atul Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: Constraints

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

Attn. : Bill Pass (RE: Materialized View)

2002-04-24 Thread Atul Kumar
. Also, please note that I am not a DBA instead I am an Oracle Developer. Thanks again Atul Kumar -Original Message- Sent: Wednesday, April 24, 2002 7:54 PM To: Multiple recipients of list ORACLE-L I would start with checking what database links are vissible. Do a select * from

problems in oracle report

2002-04-03 Thread Atul Kumar
item File. Under this few sub-menu items are displayed like Page Setup, Print, Mail, Distribute and Generate to File. How can we hide these sub-menu items? Hints/reply/solution will be highly appreciated. Thanks in advance Atul Kumar 11-91-9810350959 11-91-6817384 11-91-6817385 11-91-6817386 11-91

RE: One sql statement

2002-04-02 Thread Atul Kumar
the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Atul Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access