Search results for query: *

Hi Karluk, Sorry for disappearing for so long!! Yes tnsnames.ora is located in $ORACLE_HOME/network/admin

Karluk, Carp, I am using the same User Id in all cases. I tried both public and private db link (one after another). Issue remains in both the cases. The result of the "Select" from v$instance is also same from both the places (sql developer on client machine and sql plus on server)...

Carp, You are talking about local database, right? Local meaning where the DB link is created. I ran your query from sqlplus and from sql developer and found the result to be same.

Carp,Karluk, Thanks for your responses! Both the nodes are able to make sqlplus connection to the remote database. TNSPING also responds successfully on both the nodes. And as mentioned in my first post, db link works correctly on the servers itself. This has been baffling us and even...

I created a db link on our 11g RAC database. CREATE DATABASE LINK nst_test CONNECT TO eai_rt IDENTIFIED BY eai_rt USING 'EAIPREPROD'; When I try to use it from sql developer on my client machine in following way: select * from dual@nst_test; I get the error: ORA-12154: TNS:could not resolve the...

Hi, Recently we upgraded our database to 10G from 9i. We have been getting ORA 06531: Reference to uninitialized collection error in the new database. Some searches in metalink showed this is related to use of varray data type in the db packages. And the solution is initialize that type of...

Thanks Hoinz. This might solve my problem for now although in a subtle way.

Hi, I have a table with columns:status, gl_date and others. Status can take one of three values: CONFIRMED, REMITTED, CLEARED. My problem is that User wants to select record for a particular gl_date with preference. The order of preference is: 1.CONFIRMED 2.REMITTED 3.CLEARED If only REMITTED...

Thx for reply. But I have 72K data. So they can't be put in one worksheet ( excel's limit being 65k). or am i missing s'th from your reply.

Hi friends, I have an excel file with data in two worksheets (identical data). Total number of rows exceeds 72k. I want to sort this data on one of the columns in one go. If anyone has solution/thoughts, pls do share. Regards, Prashant

Hi Santa, Thanks for a reply. I was looking in terms of CPU usage and time it takes while using the tools (spool and utl_file). Any word on those lines? -Prashant

Hi, Which is a better choice : spooling the file from sql plus OR using utl_file from pl/sql. Considerations - * load on CPU * Time I take it that from code development point of view, spool wins the race. Any input will be highly appreciated. Regards, Prashant

Hi, I need to set a sqlplus variable using a query (since the value is stored in database). It would be something like this: define v_req_id = <select request_id from my_table> HOST uuencode '&v_req_id' a.txt|/usr/lib/sendmail <email id> Would it be possible. I tried using ACCEPT but was...