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 tnsnames connection information right into the select statement.
Can it be done?
Tom
I 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 recipien
Title: Message
We have a future
need to 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*Net does come with the
lf from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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
PROTECTED] [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
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 statistics sample 5
percent;
Takes over 2
hours:
execute
dbms_stats.gather_table_stats(o
overhead than a user.
just
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
ORAC
e 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
San Diego, California-- M
----From: Terrian, Tom (Contractor)
(DAASC) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January
15, 2003 12:54 PMTo: Multiple recipients of list
ORACLE-LSubject: Database tracking
All, I would
like to track the performance of my production databases by
running the same SQL s
Title: Message
All, I would like to
track the performance of my production databases by running the same
SQL statement against 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 t
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
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
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
13 matches
Mail list logo
