RE: oracle 9i

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

RE: Delete query

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

RE: {9i New Features: Online Reorg or DBMS_REDEFINITION Package}

2002-05-15 Thread Vadim Gorbounov
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: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: Calling an External Java Class from PL/SQL

2002-05-15 Thread Vadim Gorbounov
://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

RE: Oracle 9 Agent not starting

2002-05-06 Thread Vadim Gorbounov
Hi, Ian, Try this: 1. remove *.q files from network/agent subdir 2. removeservices.ora from network/agent subdir 3. removesnmp_*.ora from network/admin subdir 4. restart agent HTH Vadim -Original Message-From: Biddell, Ian [mailto:[EMAIL PROTECTED]]Sent: Monday, May 06,

RE: Fast refresh materialized view is not updateable

2002-04-16 Thread Vadim Gorbounov
HCL_DATA.SCD_FINANCIAL_SUMMARY_PIT_MV1 is INVALID and must complete refresh ORA-06512: at SYS.DBMS_SNAPSHOT, line 814 ORA-06512: at SYS.DBMS_SNAPSHOT, line 872 ORA-06512: at SYS.DBMS_SNAPSHOT, line 852 ORA-06512: at line 1 Mike From: Vadim Gorbounov [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED

NVARCHAR2 datatype and FK. Bug???? Feature ????

2002-04-11 Thread Vadim Gorbounov
TIA Vadim Gorbounov Oracle DBA 724 Solutions Inc. Tel:(416)226-2900 ext 5070 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: ORACLE 9i doesn't start on Linux

2002-04-11 Thread Vadim Gorbounov
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: Vadim Gorbounov INET: [EMAIL

RE: NVARCHAR2 datatype and FK. Bug???? Feature ????

2002-04-11 Thread Vadim Gorbounov
; Commit complete. SQL delete from test_pk ; delete from test_pk * ERROR at line 1: ORA-12704: character set mismatch TIA Vadim Gorbounov Oracle DBA 724 Solutions Inc. Tel:(416)226-2900 ext 5070 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: Does ORACLE standard edition support failover?

2002-02-08 Thread Vadim Gorbounov
ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Finding out used blocks in the database

2002-02-08 Thread Vadim Gorbounov
Sona, AFAIK, block dump is the only way. It is not really a query. Have a good weekend -Original Message-From: Sona [mailto:[EMAIL PROTECTED]]Sent: Friday, February 08, 2002 3:41 PMTo: Multiple recipients of list ORACLE-LSubject: Finding out used blocks in the database

RE: compressing rman backups thru pipes

2002-02-04 Thread Vadim Gorbounov
://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

RE: Oracle standby strange behavior

2002-01-30 Thread Vadim Gorbounov
Title: Oracle standby strange behavior Hi, Yuval. Did you make sure, you've got latest data transferred and applied? I bet, these two tables have largest OBJECT_ID in the original DB. Before you activate standby, do 1. On production SQL alter system switch logfile; 2. Transfer all

RE: Class does not exist error

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

RE: Top parent in START WITH...CONNECT BY

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

RE: HP-UX 11/8.1.6.x/Index-Organized Tables

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

RE: Unexplained table growth

2002-01-18 Thread Vadim Gorbounov
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: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: SQL question

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

PL/SQL Web Toolkit

2001-10-05 Thread Vadim Gorbounov
? Thank you, Vadim Gorbounov Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: disable table lock ...cannot revert it

2001-10-03 Thread Vadim Gorbounov
Rahul, Right, you can't drop or modify table after alter table t disable table lock; but alter table t enable table lock; still should work. Otherwise it could be a bug specific to you system. HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Wednesday, October 03, 2001 7:05

RE: Veritas Quickio and DB_BLOCK_SIZE

2001-10-03 Thread Vadim Gorbounov
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: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Best Uses for Oracle Designer 2000?

2001-09-21 Thread Vadim Gorbounov
(say Java, or VB whatever) dependency tracking? Thank you Vadim Gorbounov Oracle DBA -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Friday, September 21, 2001 9:00 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Best Uses for Oracle

RE: setting up HACMP and Oracle 8.1.6

2001-09-21 Thread Vadim Gorbounov
Denise, This is one of Oracle libraries, responsible for integration with third-party backup tools. Make sure, $ORACLE_HOME\lib is in LD_LIBRARY_PATH on node b. libobk.a should be here ($ORACLE_HOME\lib) HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Friday, September 21

RE: Red Hat 7.0 and raw devices

2001-09-20 Thread Vadim Gorbounov
chmod and chown into it. Check /etc/init.d and /etc/sysconfig directories reboot enjoy. Vadim Gorbounov Oracle DBA -Original Message- Sent: Thursday, September 20, 2001 8:40 AM To: Multiple recipients of list ORACLE-L Hi List, Does this couple live together? Do I need to install

RE: bitmap indexes and rule based optimizer

2001-09-12 Thread Vadim Gorbounov
No, CBO only HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Wednesday, September 12, 2001 1:05 PM To: Multiple recipients of list ORACLE-L Anybody knows whether rule based optimizer can use bitmap indexes? Alex Hillman -- Please see the official ORACLE-L FAQ: http

RE: Test for compatibility with Standard Engine

2001-09-06 Thread Vadim Gorbounov
://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

RE: listener supports no services

2001-08-31 Thread Vadim Gorbounov
Hello, If you are using non-default port you may need to add this line to init.ora: local_listener=(ADDRESS = (PROTOCOL=TCP)(HOST=your host)(PORT=your port) HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Wednesday, August 29, 2001 6:35 PM To: Multiple recipients of list ORACLE

RE: Designer 2000 install on Linux

2001-08-09 Thread Vadim Gorbounov
Hello, VMWare may be an excellent solution to get the best of two worlds - run virtual Win2000 on top of RH. Just my $0.02. Vadim Gorbounov Oracle DBA -Original Message- Sent: Thursday, August 09, 2001 4:51 PM To: Multiple recipients of list ORACLE-L

RE: Brain dead Friday question

2001-08-03 Thread Vadim Gorbounov
No, Srini, It's not friday, simply there is no view like this... Check Metalink Note:132629.1, this may help if you do really want all locks. HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Thursday, August 02, 2001 7:43 PM To: Multiple recipients of list ORACLE-L Folks, How

RE: Oracle vs. MySQL

2001-08-01 Thread Vadim Gorbounov
123456 to the number(1) field - further migration to Oracle may give you some pain Bright side it's fast (beats Oracle sometimes) and free. Regards, Vadim Gorbounov Oracle DBA ( not mySQL:) ) -Original Message- Sent: Wednesday, August 01, 2001 12:48 PM To: Multiple recipients of list

RE: iAS 1.0.2.2. and mod_ssl CA

2001-07-31 Thread Vadim Gorbounov
Hi, Patrice, It seems to be Certificate Authority, like http://www.verisign.com/ Regards Vadim Gorbounov Oracle DBA -Original Message- Sent: Tuesday, July 31, 2001 10:42 AM To: Multiple recipients of list ORACLE-L I am reading technical note 112490.1, which explains how to set up

RE: iAS 1.0.2.2. and mod_ssl CA

2001-07-31 Thread Vadim Gorbounov
Patrice, Nop, it's not free. Simply it's different service to your Apache, like gas for new car - your either can put or not - it still shines. Seriously, the Certificate needs some efforts and resources from Authority to support - it's like domain name. Cheers, Vadim Gorbounov Oracle DBA

RE: (Fwd) Oracle 8i and clustering [NT]

2001-07-25 Thread Vadim Gorbounov
Hi Eric, Ali, I'd install Oracle locally and put data/control/redo on shared. Although this means some redundancy and more administration, you will be able to narrow down maintenance window while patching/upgrading. Vadim Gorbounov Oracle DBA -Original Message- Sent: Wednesday, July

RE: Input truncated

2001-07-24 Thread Vadim Gorbounov
Hi, Andrea , Nothing to worry about. If you want to get rid of this message, remove blank lines after procedure code. HTH Vadim Gorbounov Brainbench Master Oracle DBA www.brainbench.com -Original Message- Sent: Tuesday, July 24, 2001 10:01 AM To: Multiple recipients of list ORACLE-L I

RE: Can't code for s.... peanuts

2001-07-23 Thread Vadim Gorbounov
Hi, Michael, This happens because you dont specify this EXECUTE as function call, try this: declare b boolean; begin b := check_for_name('Cruise'); end; / HTH Vadim Gorbounov Brainbench master of Oracle DBA www.brainench.com -Original Message-From: [EMAIL PROTECTED

RE: SQLJ vrs PLSQL

2001-07-23 Thread Vadim Gorbounov
Hello, Christopher, It is not faster. SQLJ is jdbc by nature, simply SQLJ precompiler facilitates some tasks like variable binding. After compilation this is normal java code. PL/SQL always outperformes Aurora JVM making SQL operations. HTH Vadim Gorbounov Oracle DBA -Original Message

SGA, miscellaneous keeps growing...

2001-07-03 Thread Vadim Gorbounov
. Fortunately, now I can schedule this every weekend, but the fact itself troubles me. Nothing on Metalink. What looks specific about this database, I've got job using UTL_HTTP many times per day ... Did anybody experience this problem? Any idea where to look at? Thank you Vadim Gorbounov Oracle DBA

RE: SGA, miscellaneous keeps growing...

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

RE: SGA, miscellaneous keeps growing...

2001-07-03 Thread Vadim Gorbounov
... Did anybody experience this problem? Any idea where to look at? Thank you Vadim Gorbounov Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: Database writer

2001-06-04 Thread Vadim Gorbounov
Hi, Kevin, Maybe this query will help: SQLselect PROGRAM from v$process where PROGRAM like '%DBW%'; Regards Vadim Gorbounov Oracle DBA -Original Message- Sent: Monday, June 04, 2001 11:56 AM To: Multiple recipients of list ORACLE

RE: 4 join methods?

2001-06-01 Thread Vadim Gorbounov
operations: Nested Loops (NL) Join Sort-Merge Join Hash Join (not available with the RBO) Cluster Join Cheers, Vadim Gorbounov Oracle DBA

RE: ORACLE NAMES /LDAP

2001-05-31 Thread Vadim Gorbounov
Hi, Actually, it's not so bad. OiD is licensed separately ONLY when used as general purpose directory service. Check Metalink Note:135696.1 13. Do I need to license OID when deploying the directory for NET8 ? Answer -- No, deploying OID for NET8 is free of charge. Vadim Gorbounov Oracle

RE: Rebuilding indexes

2001-05-31 Thread Vadim Gorbounov
# on primary becomes bigger, simply take hot backup of this particular datafile, shutdown standby instance, replace the file with the backup, mount standby database and continue recovery. I setup cron to do this. Works fine. HTH Vadim Gorbounov Oracle DBA -Original Message- Sent

RE: Analyze table and locking

2001-05-30 Thread Vadim Gorbounov
Yes, table is exclusively locked when ANALYZE ... VALIDATE. Until 9i, I believe. Vadim Gorbounov Oracle DBA -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 30, 2001 7:22 AMTo: Multiple recipients of list ORACLE-LSubject

RE: Analyze table and locking

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

RE: OEM /98 / and 8.1.6 on Linux

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

RE: cdump, bdump, udump

2001-05-15 Thread Vadim Gorbounov
Rao, I didnt follow this thread from the beginnig, but if you primary task is to release disk space, try echo alert.log (or cat /dev/null listener.log) instead of rm. HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Tuesday, May 15, 2001 2:50 PM To: Multiple recipients of list

RE: Duplicate DB to different host using RMAN/Veritas Netbackup .

2001-05-14 Thread Vadim Gorbounov
env variable NB_ORA_CLIENT=backup client; export NB_ORA_CLIENT, b/ set ORACLE_SID to original DB SID 3. restore infrastructure (like appropriate directories, UNIX permissions, init.ora) should be ready. HTH Vadim Gorbounov Brainbench Master Oracle DBA www.brainbench.com -Original

RE: Dead Lock in Temporary Tables 8.1.6 ... HELP !

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

RE: Can I partition my primary key constraint index?

2001-05-11 Thread Vadim Gorbounov
Hello, Cherie, Short note first - when you drop primary key the associated index will be dropped too. To partition the index you will create this index first and then alter table table name add constraint index name primary key(column list); HTH Vadim Gorbounov

RE: Data Reporting tools

2001-05-10 Thread Vadim Gorbounov
to include dynamic graphics (from db, for example). No problem to put a picture. Vadim Gorbounov, Oracle DBA -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 10, 2001 2:51 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Data Reporting tools

RE: restrict login with known IP address

2001-05-09 Thread Vadim Gorbounov
To: Multiple recipients of list ORACLE-L What about the old protocol.ora? -Original Message- From: Vadim Gorbounov [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 20:17 To: Multiple recipients of list ORACLE-L Subject: RE: restrict login with known IP address Hello

RE: restrict login with known IP address

2001-05-08 Thread Vadim Gorbounov
Hello, Joseph Try something like this CREATE OR REPLACE TRIGGER IP_CATCH AFTER LOGON ON DATABASE BEGIN if ora_client_ip_address = '172.16.0.175' then raise_application_error(-20001, 'No way from '||ora_client_ip_address); end if; END; / HTH Vadim Gorbounov Oracle DBA -Original

RE: Listener.log

2001-04-25 Thread Vadim Gorbounov
Thank you, John.The best solution. Vadim -Original Message-From: John Carlson [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 24, 2001 7:45 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Listener.log For those of you who did not see my response in the thread of

RE: ORA-01458

2001-04-24 Thread Vadim Gorbounov
Sonja, this is bug. Promised to be fixed in 8.1.6, and back again :( Workaround is to create table .. as select .. OR simply create table, than insert... HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Tuesday, April 24, 2001 11:26 AM To: Multiple recipients of list ORACLE-L

RE: Listener.log

2001-04-24 Thread Vadim Gorbounov
Hello, You have to restart your listener. It continues towrite to "invisible" file (inode without any reference from directories). Welcome to UNIX. HTH Vadim Gorbounov Oracle DBA -Original Message-From: Nguyen Thanh-truc [mailto:[EMAIL PROTECTED]]Sent: Tuesday

RE: sort_area_size + temp tablespace extent sizing

2001-04-24 Thread Vadim Gorbounov
Hello, Ade, You are right, Oracle needs one-block header, and you have to add this block to optimize performance. The extent size my be one block + N*SORT_AREA_SIZE N depends on size of typical sort operations. HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Tuesday

RE: Sqlloader

2001-04-19 Thread Vadim Gorbounov
Hell Roland, It is a table, you are about to load in, isnt it? If yes, there is better way - use "load data .. into table ... truncate". I dont think, Oracle has something to answer your original question. HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Thursday, Apri

RE: Need Help.

2001-04-19 Thread Vadim Gorbounov
Hello, Uday, First step, try ANALYZE TABLE ... COMPUTE STATISTICS for EVERY table participating your query(es). Check and compare execution plan before and after analyze. HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Thursday, April 19, 2001 3:32 PM To: Multiple recipients

RE: Insert ... nologging

2001-04-19 Thread Vadim Gorbounov
is invalid. HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Thursday, April 19, 2001 4:48 PM To: Multiple recipients of list ORACLE-L Hello all, I'm trying to do inserts with NOLOGGING. It works if I don't specify insert columns OR if I have no where clause. If I have EITHER

RE: import and strange PK violation error ???

2001-04-19 Thread Vadim Gorbounov
(unlike PRIMARY KEY), and this index may be unique. HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Thursday, April 19, 2001 4:56 PM To: Multiple recipients of list ORACLE-L All, I'm import from a dmp file. I already disable PK, FK on all the tables, but when I import I still got

RE: Ability for non DBA user to kill session.

2001-04-17 Thread Vadim Gorbounov
Hello, Li, I believe, stored procedure is the best and simplyest way for this purpose. There is nothing wrong giving ALTER SYSTEM to _procedure owner_. End user will be limited to execute this procedure only, and will not require ALTER SYSTEM for him/herself. Best regards, Vadim

RE: How to get rid off file permanently?

2001-04-12 Thread Vadim Gorbounov
Hi, Andrea , You HAVE to drop and create tablespace. Regards, Vadim Gorbounov Oracle dba -Original Message- Sent: Thursday, April 12, 2001 1:36 PM To: Multiple recipients of list ORACLE-L Hi all, I need to permanently get rid off some files from the database. I did this: 1. alter

RE: database links

2001-04-11 Thread Vadim Gorbounov
Hi, Millie, Try this location ftp://oracle-ftp.oracle.com/server/ HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Wednesday, April 11, 2001 10:26 AM To: Multiple recipients of list ORACLE-L I have set the global_names parameter to false on my mainframe database ORS1

RE: Oracle Patches

2001-04-11 Thread Vadim Gorbounov
Hi, Stefan , try this ftp://oracle-ftp.oracle.com/server/ HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Wednesday, April 11, 2001 4:30 AM To: Multiple recipients of list ORACLE-L Hi, since I don't have Meta Link, where can I possibly get any Oracle patches/updates etc

RE: index on table with 3 million rows ???

2001-04-11 Thread Vadim Gorbounov
, better to set STORAGE manually for objects of this size. 2b. If yes - see 1 and than, if still need more space - add this space. Consider partitioning. Segments of 1Gb+ size are not very comfortable to handle. Best regards, Vadim Gorbounov Oracle DBA -Original Message- Sent: Wednesday

RE: Is ALTER TABLE ADD COLUMN a time-consuming operation ?

2001-04-05 Thread Vadim Gorbounov
to be NOT NULL, better to add NULL colomn, set desired value via several smaller updates (range limited by appropriate WHERE ) and than modify NOT NULL. If you'll try to ADD NOT NULL with DEFAULT, estimated time will be full table update :) Hope this helps Vadim Gorbounov

RE: killing a thread

2001-04-05 Thread Vadim Gorbounov
Title: RE: killing a thread Hi, It WAS for windows until 8.1.x, i believe. There is a kill in UNIX, no need for special utility. How to use: select spid from v$process, v$session where paddr=addr and sid = SID; then orakill SID spid thread will terminate... HTH Vadim Gorbounov

RE: OEM Repos install error.

2001-04-02 Thread Vadim Gorbounov
Hi Mark, I installed 2.1 several times, nothing like this (never on the same box with 8.1.7). I'm pretty sure, you need either separate ORACLE_HOMEs for 8.1.7 and OEM 2.1, or go with OEM 2.2, as Clint told. Vadim Gorbounov Oracle DBA -Original Message

RE: identify which logs are need to start recovery

2001-03-29 Thread Vadim Gorbounov
: 0x.0001d187 11/16/2000 15:37:16 thread:1 rba:(0xb6.6d.160) I'm not absolutely sure, this is correct, but looks like for me. Best regards, Vadim Gorbounov Oracle DBA -Original Message- Sent: Thursday, March 29, 2001 3:19 AM To: Multiple recipients

RE: dbms_obfuscation package

2001-03-21 Thread Vadim Gorbounov
Vadim Gorbounov Oracle DBA -Original Message- Sent: Wednesday, March 21, 2001 4:30 PM To: Multiple recipients of list ORACLE-L help! I am by no means the world's best PL/SQL programmer (heck, I can barely program in it, PL/SQL 101 is on my desk at home) I am trying to see

RE: dbms_obfuscation package

2001-03-21 Thread Vadim Gorbounov
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: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: How to find SEQUENCE#

2001-03-20 Thread Vadim Gorbounov
$log_history. Regards. -Mensaje original- De: Vadim Gorbounov [SMTP:[EMAIL PROTECTED]] Enviado el: lunes 19 de marzo de 2001 21:11 Para: Multiple recipients of list ORACLE-L Asunto: How to find SEQUENCE# Hi, DBAs, Can anybody give me a guess, how to find out

How to find SEQUENCE#

2001-03-19 Thread Vadim Gorbounov
or v$log. Where to look this correspondence in standby database. Thanks for Your Help Vadim Gorbounov Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: jre.exe using up too much CPU

2001-03-13 Thread Vadim Gorbounov
Hi, Patrice, This is not normal. Mine is running on 128m, no performance issues. I suggest you to check $ORACLE_HOME/sysman/log/oms.nohup. It there is nothing unusual, I'd turn on OMS tracing. I've seen good note on Metalink 69522.1. Regards, Vadim Gorbounov

RE: Netbackup and RMAN

2001-03-09 Thread Vadim Gorbounov
and mature. Disadvantage - if you're loosing catalog - all backups are useless. You need to take double care about catalog. Vadim Gorbounov Oracle DBA -Original Message- Sent: Thursday, March 08, 2001 9:50 PM To: Multiple recipients of list ORACLE-L We are planning to use

RE: Change tablespace for Local Index Partition

2001-03-07 Thread Vadim Gorbounov
partition will go to TABLESPACE xxx. Vadim Gorbounov Oracle DBA -Original Message- Sent: Wednesday, March 07, 2001 12:46 PM To: Multiple recipients of list ORACLE-L Hi, I'm running Oracle 8.0.5 and I have a partitioned table with local indexes. I try to: put partition

RE: Change tablespace for Local Index Partition

2001-03-07 Thread Vadim Gorbounov
partition will go to TABLESPACE xxx. Vadim Gorbounov Oracle DBA -Original Message- Sent: Wednesday, March 07, 2001 5:06 PM To: Multiple recipients of list ORACLE-L Alex, You have the syntax correct, but your index name seems invalid. Also, there is no need to put

RE: bitmap index problem

2001-03-06 Thread Vadim Gorbounov
Hi Leslie, It seems to be Standard Edition. You need EE for bitmap idx to be enabled. Vadim Gorbounov Oracle DBA -Original Message- Sent: Tuesday, March 06, 2001 12:40 PM To: Multiple recipients of list ORACLE-L Hi all, When I tried to build a bitmap index (8.1.5), I got this: ERROR

RE: rename database

2001-03-06 Thread Vadim Gorbounov
Title: rename database Hi, Lisa, You can change database global name, but db_name change requires controlfile to be recreated. Vadim Gorbounov Oracle DBA -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, March 06, 2001 3:40 PMTo: Multiple

RE: [Q] why sequence number jump?

2001-03-06 Thread Vadim Gorbounov
e list archive: http://www.LAZYDBA.com/odbareadmail.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet ac

RE: Drop a column in a 9 million records table

2001-03-05 Thread Vadim Gorbounov
Chris, be careful, Truncate will kill all 9 million records - everything. Truncate acts vertically. Drop column has very different effect :) Records a safe, but one column is gone. It acts horizontally. Use set unused, if waste space is not an issue. Just my $0.02 Vadim Gorbounov Oracle DBA

RE: EJB Oracle Sequence

2001-02-26 Thread Vadim Gorbounov
This issue should be addressed by appropriate deployment descriptor, and implementation essentially depends on development tool. CMP :-(. Vadim Gorbounov Oracle DBA -Original Message- Sent: Monday, February 26, 2001 10:25 AM To: Multiple recipients of list ORACLE-L Hello , One

RE: Mailing frm Oracle

2001-02-22 Thread Vadim Gorbounov
On 8.1.6+ you can use UTL_SMTP. Vadim Gorbounov Oracle DBA -Original Message- Sent: Thursday, February 22, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Hi Everybody, I wanted to forward a mail to a particular Id thru an Oracle Procedure , can anybody tell me whether I can do

RE: Get Java from database?

2001-02-15 Thread Vadim Gorbounov
(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: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: recovery catalog creation

2001-02-07 Thread Vadim Gorbounov
Hi, You dont have "database" in your tnsnames.ora or whatever name service you use. Sure, sqlplus user/user@database will give you the same. You need to add this entry to your service list on this machine, for exmple into tnsnames.ora Vadim Gorbounov

RE: V$log Status

2001-02-07 Thread Vadim Gorbounov
datafiles on RAID-5? You have to distribute datafiles over several disks (there are two main options - raid with striping, or manual distribution) and may be consider partitioning for this table. Many suggestions in this thread are also very reasonable. Just my $0.02 Vadim Gorbounov

RE: RMAN

2001-02-06 Thread Vadim Gorbounov
Title: RMAN Hi, Lisa, You need separate catalogs for rman 8.1.5 and 8.1.6, though you can put then on a single machine in different schemas. rman815 scripts could be found in ORACLE_HOME815/rdbms/admin: catrman, as far as I remember. Vadim Gorbounov Oracle DBA -Original Message

RE: Index Usage Monitoring

2001-02-05 Thread Vadim Gorbounov
Hi, Why not to use otrace? Of cource, you may need some space to save trace results, but you'll definitely get complete statistics. Vadim Gorbounov Oracle DBA -Original Message- Sent: Tuesday, January 30, 2001 3:57 PM To: Multiple recipients of list

RE: Index Usage Monitoring

2001-02-05 Thread Vadim Gorbounov
to revise segment parameters. But this doesn't not completely the same task, as in question. Vadim Gorbounov Oracle DBA -Original Message- Sent: Monday, February 05, 2001 1:57 PM To: Multiple recipients of list ORACLE-L I do know there is a way to tell which indexes are acc