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
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
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
://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
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,
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
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
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
;
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
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
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
://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
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
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
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
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
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
).
--
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
?
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
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
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
(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
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
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
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
://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
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
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
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
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
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
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
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
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
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
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
. 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
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
...
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
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
operations:
Nested Loops (NL) Join
Sort-Merge Join
Hash Join (not available with the RBO)
Cluster Join
Cheers,
Vadim
Gorbounov
Oracle DBA
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
# 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
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
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
(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
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
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
(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
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
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
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
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
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
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
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
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
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
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
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
(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
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
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
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
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
, 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
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
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
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
: 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
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
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
$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
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
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
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
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
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
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
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
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
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
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
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
(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
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
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
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
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
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
90 matches
Mail list logo