Title: Message
Does anyone have an
example of connecting to a remote database without a database link? I
think that I have seen it done before by putting in the username and password
and tnsnamesconnection information right into the select statement.
Can it be done?
Tom
Title: Message
We have a future
needto create an Oracle database on a mainframe (MVS) which will then pull
data from an Oracle database on an HPUX box. I know nothing about MVS so
does anyone know of any connectivity problems between the two boxes? For
example,SQL*Netdoes come with the
don't know about
Pro*Cobol, I would assume so. Database links between MVS and HPUX work
as expected.
Allan
-Original Message-From: Terrian, Tom
(Contractor) (DAASC) [mailto:[EMAIL PROTECTED] Sent: Thursday,
July 10, 2003 11:00 AMTo: Multiple recipients
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.net
--
Author: Terrian, Tom (Contractor) (DAASC)
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
Title: Message
I have never had
good luck with DBMS_STATS. It seems that the old analyze runs much
faster.
Runs in 45
seconds:
analyze table
log_trans partition (log_trans_20030104) estimate statisticssample 5
percent;
Takes over 2
hours:
execute
] [mailto:[EMAIL PROTECTED] On Behalf Of Terrian, Tom (Contractor)
(DAASC)Sent: Tuesday,
February 25, 2003 12:13 PMTo: Multiple recipients of list
ORACLE-LSubject:
DBMS_STATS
I have never had good luck with
DBMS_STATS. It seems that the old analyze runs much
faster
Title: Message
All, I would like to
track the performance of my production databases by runningthesame
SQL statementagainst each database every 5 minutes or so and
recording the results. For example:
sql set timing
on;
sql select
count(*) from dba_tables;
That was I would
know if they
__
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 opinion is an
art!
-Original Message-From: Terrian, Tom (Contractor
(like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Terrian, Tom (Contractor) (DAASC)
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
my 2 cents but, good luck!
Tom Mercadante Oracle Certified Professional
-Original Message-From: Terrian, Tom (Contractor)
(DAASC) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January
15, 2003 1:59 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Database tracking
I
Title: Message
ummm...I just
truncated all of the system tables in a new database (that's not good). No
backups yet. Anyway to recover from this or do I have to recreate the
database?
Thanks,
Tom
Terrian
on Oracle's Data
Unloader. But if it's a new database, it's probably simpler to recreate.
--- Terrian, Tom (Contractor) (DAASC) [EMAIL PROTECTED] wrote:
ummm...I just truncated all of the system tables in a new database
(that's not good). No backups yet. Anyway to recover from this or do
by "SYSTEM" or owned by "SYS", just
making sure?
Waleed
-Original Message-----From: Terrian, Tom (Contractor)
(DAASC) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January
08, 2003 9:19 AMTo: Multiple recipients of list
ORACLE-LSubject: Tr
13 matches
Mail list logo