Problem with Database Link
Hi Friends, I am facing a problemin operating with database link. One of the machine has Personal Oracle 8i installed. In the same machine the client of Oracle Enterprise 8i is also installed, whose server is installed on the Database server machine. Now in the client machine, TNSNAMES.ORA files of both the enterprise client and that of personal is having the same entry of host string, i.e. the host name version is same for both the versions. ADatabase link is created from the personal oracle for the oracle enterprise. Now when the select statement is fired from Personal Oracle 8i fetching data from Oracle enterprise using the database link, it is giving TNS ERROR specifying OPERATION TIME OUT. Can anybody help in solving the problem? Thanks in advance. Rakesh amtrix Infosystems Ltd. Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more
RE: recordset as argument
Hi Caver, Can u pls give in details with a sample code, if posible the implementation of the recorset(or resultset) in REF CURSOR. With Regards Rakesh Banerjee From: Toepke, Kevin M [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: recordset as argument Date: Thu, 04 Apr 2002 05:33:26 -0800 In Oracle 8.x you can pass in a INDEX BY Table, Varray, etc. In Oracle 9i a procedure can accept a REF CURSOR as an input parameter. Caver -Original Message- Sent: Thursday, April 04, 2002 8:08 AM To: Multiple recipients of list ORACLE-L Hi Gurus ! Is it possible to pass recordset or cursor as argument in stored procedure ?? thanx in advance.. Shishir Kumar Mishra Agni Software (P) Ltd. www.agnisoft.com http://www.agnisoft.com _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: rakesh banerjee 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-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 (like subscribing).
Help needed
HELP Hi, I am working with Oracle 8i version in our ERP applications. I have one question regarding the backup of Oracle database. In the database I am designing it is required to partition the database as per financial year.Almost all the tables will be partitioned accordingly. I want to know WHETHER IT IS POSSIBLE TO TAKE THE BACKUP OF INDIVIDUAL PARTITIONS (i.e. OF THE YEARWISE DATA). IF YES, THEN HOW IT CAN BE DONE. Waiting for your reply at the earliest, as my design will be dependent on your feedback. With Regards Rakesh Banerjee _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: rakesh banerjee 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-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 (like subscribing).
Re: Help needed
Hi, Thanks for ur answer. Can u please help me in giving the code about how to implement it, i.e. how to write the code specifying the particular tablespace, because as the new financial year will appear, new tablespace will be required. So how it can be managed to put the code in the DDL script so that it assigns the tablespace automatically. Waiting for ur reply. With Regards Rakesh Banerjee From: Igor Neyman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Help needed Date: Wed, 03 Apr 2002 06:53:33 -0800 Put each partition into separate tablespace. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 9:18 AM HELP Hi, I am working with Oracle 8i version in our ERP applications. I have one question regarding the backup of Oracle database. In the database I am designing it is required to partition the database as per financial year.Almost all the tables will be partitioned accordingly. I want to know WHETHER IT IS POSSIBLE TO TAKE THE BACKUP OF INDIVIDUAL PARTITIONS (i.e. OF THE YEARWISE DATA). IF YES, THEN HOW IT CAN BE DONE. Waiting for your reply at the earliest, as my design will be dependent on your feedback. With Regards Rakesh Banerjee _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: rakesh banerjee 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-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 (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman 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-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 (like subscribing). _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: rakesh banerjee 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-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 (like subscribing).