Re: dblink problem ( ORA-02019 )

Hi, Use Drop database link name. (if the link is a private link and u are the owner) Drop public database link name. Hope this helps shreepad

Re: how can listener list on two ports for the same db?

Hi Helmut , I will try to clarify using an example. Tnsnames.ora ghi100 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = your IP address of the server where database resides )

Re: how can listener list on two ports for the same db?

Hi Helmut , I will try to clarify using an example. Tnsnames.ora ghi100 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = your IP address of the server where database resides )

[no subject]

Hi, I am facing a very strange problem. Oracle 7.3.4.4.1 and HP 10.2 I do an analyze of a huge table (more than 46 million records) . The query which hits this table and 2 other table has an RULE hint . On the day analyze fails on the big table, performance is very very slow . But with

RE: Size of segment

Hi, Thanks to all those who replied. Just clearing the structure. I have Hp LVM and the tables and indexes are on different tablespaces and different disks . Since the growth pattern has changed drastically , the no of extents have increased tremendously . Hence the need to rebuild the

Size of segment

Hi, I have segments (Tables and indexes) which go into 500 MB -- 1 GB . I intend to do a rebuild since they are fragmented. Is it beneficial to have a single extent of 500 Mb or multiple extents are ok ? (maybe 4 --5) My contention is that so long as the extents are contiguous ( I could do

Re: Problem in 9i - Is this a bug?

Hi, 1) Solaris 8 2) Oracle apps server 11.5.4 During installation I am getting response file error. Can anyone give me leads on this? shreepad -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network

Problems in replication

Hi, We have a replication between production and reporting database. Prodn Server Reporting server HP-UX 10.2HP-UX 10.2 oracle 7.3.4.4.1 oracle 7.3.4.4.1 The os and oracle patches on the production server and reporting server are in sync.

Re: Archive log dest full

Hi Sean, One method would be to write a script which checks regularly the free space on the archive dest . After it is say 60 % full backup the archive logs to another filesystem or tape . This script would have to work as a deamon. If you are using any backup utility , it may have such

Re: Oracle and Corba

Hi John, See if this is of any help. Oracle 8i manual. java.816/a81356/overview.htm#1013958 HTH shreepad -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Re: close_cached_open_cursors error

Hi Eva , Closed_cache_open_cursors is a parameter in Oracle 7.3.4.x .This is obsolete in oracle 8.x If set in u r init.ora remove it. OR Some product is setting this at Alter system /Alter session HTH shreepad. This parameter controls whether cursors

Re: Problem Running DDL SQL Script

Hi Ken, The syntax seems to be ok . It worked at my environment. So u may have to look at privileges or status of tablespaces. Why are u creating tables as SYSTEM ? .. Just a query. shreepad

Re: Odd Listener.ora Stanza

Hi , The settings in the listener.ora point to EJB specifies Java Remote Method Invocation (RMI) as the transport protocol. Oracle8i JServer implements RMI over IIOP. Because the CORBA Internet Inter-ORB Protocol (IIOP) is the transport protocol for CORBA and for a future version of RMI,

RE: Oracle 7 documentation - Good One

Hi All, It's nice to learn that there are so many Oracle 7 database's still out there . It does not give me a Complex any longer . Oracle 7.3.4.4.1 DBA and Oracle 8i's tinkrer . Probably I am already outdated with Oracle 9i out in the market . Shreepad -- Please

OPS on LINUX

able to configure OPS on LINUX. ? What are the Related versions of LINUX and ORACLE. ? Thanks. shreepad -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Re: Last Update

Hi, Thanks for the clarification. Always welcome. shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: However you can query the view dba_tab_modifications for checking when and how many updates/deletes/inserts/truncate have been

Re: Temp

: Shreepad Vaidya 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 this mailing list, send an E

Re: Last Update

shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official

Re: User Memory

if they are actually changing the settings. HTH shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: Hi everybody, i've been monitoring my users connections for i alittle while now and i have noticed something that's worrying me. i'm

Re: Any idea about DIANA in Oracle...??

= machine-dependent pcode */ HTH shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: Hi DBAs, I have seen some packages / procs.. getting created with DIANA as names while executing CATALOG / CATPROC scripts. Does anyone have

Script for reverse eng of table

Hi, This script for reverse eng of tables works on 7.3 .not on 8.0 or above . HTH. shreepad (See attached file: ddltab.sql) -- This script is created to obtain the ddl for the tables. -- By SHREE. -- Not Nulls are not included in syntax as they are picked up in a

RE: Binding a process to a CPU .

Hi Steve , Your article was very informative . Thanks a lot. I will have to definitely rethink on these issues. shreepad. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services

Binding a process to a CPU .

Problems. shreepad. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Capacity Planning.

. But the other two are completely new ones. Any additions to the above parameters shreepad . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Re: Shutdown database abort

time) ) As far as possible do not give Shutdown abort except in extreme circumstances . In Oracle 8 onwards 1) Shutdown transactional will allow you to complete the transaction. shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc

Re: Security, Password policy

: Shreepad Vaidya/EMEA/ALLTELCORP) Hi all, Do you guys have any password policy knowledge to share? For Solaris 7, and Oracle 8i 8.1.6, Can anyone introduce me some good URL sites for those white paper ? Thank You Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

Idle time

-- Author: Shreepad Vaidya 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 this mailing