Re: Any woraround for this ....?
Title: Message Richard, You are right. But for me, the organization for which I work, has around 20 branches and not all the branches has support person. So It will be difficult for us to get the DMP's on a regular basis. The requirement is that, we are in the process of making a sort of global db of all our branches by automating this. The script that I aim will be run and able to gather the data entered for the day and send it by mail. The other station can just run the same to store the data. Muths - Original Message - From: Richard Huntley To: Multiple recipients of list ORACLE-L Sent: Thursday, September 05, 2002 7:03 PM Subject: RE: Any woraround for this ? Muths, What is the purpose of having the table data dumps? If you're just going to use them to load data back into Oracle, why not just use table level export/import. -Original Message-From: Muthaiah, VSNL [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 05, 2002 1:58 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Any woraround for this ? Thanks. I did as you said but now with the following error. It writes for the first table and then this error crops. SQL> exec extractBEGIN extract; END; *ERROR at line 1:ORA-20001: 1User-Defined ExceptionORA-06512: at "SCOTT.EXTRACT", line 119ORA-06512: at line 1 Am i missing some thing? Rgds, Muths - Original Message - From: Seefelt, Beth To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 04, 2002 7:18 PM Subject: RE: Any woraround for this ? Remove all the dbms_output calls and use utl_file. It should get around this error, and its not possible to get the below error with utl_file so you must have missed something when you tried it the first time. HTH, Beth -Original Message-From: Muthaiah, VSNL [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 6:48 AMTo: Multiple recipients of list ORACLE-LSubject: Any woraround for this ? Hi, I'm writing a procedure/script for extract the data of all the tables in a schema. When I am trying to spool/write into a file, I am getting the following error. ORA-20001: -2ORA-2: ORU-10028: line length overflow, limit of 255 bytes per lineORA-06512: at "SCOTT.EXTRACT", line 115ORA-06512: at line 1 First I tried to spool to a file.But got the error line length overflow. I have tried using the UTL_FILE option also. But getting the same error. Can anyone in the list has any work around for this? Thanks in Advance, Muths
Re: Any woraround for this ....?
Title: Message Thanks. I did as you said but now with the following error. It writes for the first table and then this error crops. SQL> exec extractBEGIN extract; END; *ERROR at line 1:ORA-20001: 1User-Defined ExceptionORA-06512: at "SCOTT.EXTRACT", line 119ORA-06512: at line 1 Am i missing some thing? Rgds, Muths - Original Message - From: Seefelt, Beth To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 04, 2002 7:18 PM Subject: RE: Any woraround for this ? Remove all the dbms_output calls and use utl_file. It should get around this error, and its not possible to get the below error with utl_file so you must have missed something when you tried it the first time. HTH, Beth -Original Message-From: Muthaiah, VSNL [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 6:48 AMTo: Multiple recipients of list ORACLE-LSubject: Any woraround for this ? Hi, I'm writing a procedure/script for extract the data of all the tables in a schema. When I am trying to spool/write into a file, I am getting the following error. ORA-20001: -2ORA-2: ORU-10028: line length overflow, limit of 255 bytes per lineORA-06512: at "SCOTT.EXTRACT", line 115ORA-06512: at line 1 First I tried to spool to a file.But got the error line length overflow. I have tried using the UTL_FILE option also. But getting the same error. Can anyone in the list has any work around for this? Thanks in Advance, Muths
Any woraround for this ....?
Hi, I'm writing a procedure/script for extract the data of all the tables in a schema. When I am trying to spool/write into a file, I am getting the following error. ORA-20001: -2ORA-2: ORU-10028: line length overflow, limit of 255 bytes per lineORA-06512: at "SCOTT.EXTRACT", line 115ORA-06512: at line 1 First I tried to spool to a file.But got the error line length overflow. I have tried using the UTL_FILE option also. But getting the same error. Can anyone in the list has any work around for this? Thanks in Advance, Muths
OCP-Network Exam
Hi, Greetings, I am on the preparation for my OCP 8i Network Administration exam. I welcome any tips or questions or model papers. So that i can prepare myself well for the exam. Looking forward to your inputs, With best regards, Muths _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muthaiah 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).
Oracle Designer Connection with server
Hi List, I am in a problem, not being able to connect from designer/developer to the oracle db. Environment PlatformWindows NT 4.0 Service Pack 6a - standalone server DB Oracle 8.1.6 EE Designer6i Developer 6i As suggested in the release notes of Designer, I have first installed the Designer in the default_home and then installed the database in a different home. Developer was installed subsequently in the same home where designer was installed. My database works fine from SQL*Plus. But when, I tried to connect either from designer or developer, I am getting TNS could not resolve service name. I had created an alias using net easy config. I am getting the same above error when i tried to connect while using the alias as the service name. Could anyone shed some light to resolve this to connect from Designer/Developer, Thanks in Advance, Muths ps: I am posting this here as some one who could help me, who have not subscribed to the DEV2K list.
Is CKPT process is Mandatory in 8i
Hi List, Today we had a big argument at our work place whether CKPT is Mandatory/Optional process in 8i. My contention is that it is an optional process. I am sure it was optional in 7.3 and later became mandatory in 8. Gurus, can you please clarify whether CKPT is a Mandatory or Optional process in 8i. TIA, Muths _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muthaiah 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).
Partly OT: Developer seeks job
Hi, I am from India. Due to downsizing by an MNC, I am in search of job as a Developer/ Analyst Programmer/Systems Analyst. I am proficient in Oracle, PL/SQL, Developer 2000 Products. I am an Oracle Certified Application Developer and Part DBA. If any of you come across any such openings, please send me an mail off the list. I am eligible to work in U.S.A and Australia and India. I am posting this here as it get noticed by a lot of Oracle professionals. Sorry for posting this here. Please bear with me. Thanks, Muths _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muthaiah 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: Quer
Hi, It allows you to have up to 1000 columns. If it allows more than this then there will be performance issues. BTW, How much column you want to have as max? Muthaiah At 12:30 AM 6/12/01 -0800, you wrote: Hi All, Simple question... How many columns one table will allow.. and why only that number of columns are allowed. Thank in Advance S.S.Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sambasivarao_Potla 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). Muthaiah Chinnaveerappan (Muths), Systems Analyst, Chennai, India. Tel : 91-44-2435034 Email : [EMAIL PROTECTED] "Do not go where the path may lead, go instead where there is no path and leave a trail."
What stands for i in Oracle 8i
Hi, I am just curious about to know for what that i stands for in Oracle 8i. Can any one shed some light? Thanks, Muths "Do not go where the path may lead, go instead where there is no path and leave a trail."
Re: create temporary tablespace question
Hi, The first option always remain as temporary tablespaceand can not be made permanent. but whereas the second option can be altered later as permanent. Rgds, Muthaiah At 10:45 PM 6/4/01 -0800, you wrote: Hi all, What is the different between: CREATE TEMPORARY TABLESPACE temp bla bla ; and CREATE TABLESPACE temp bla bla TEMPORARY ; Thank You Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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). Muthaiah Chinnaveerappan (Muths), Systems Analyst, Chennai, India. Tel : 91-44-2435034 Email : [EMAIL PROTECTED]
Re: unhandled user-defined exception
Hi, You have to handle the exception explicitly. You can handle them by trapping When too_many_rows, when no_data_found, when zero_divide. After using these exceptions also if you get the error again, then you can go for when others as a final resort. Hope this helps, Muthaiah At 03:25 AM 5/17/01 -0800, you wrote: Hi Gurus I am getting the error attached below when trigger fires. what could be the reasons for this error. DB error: ORA-06510: PL/SQL: unhandled user-defined exception Thanks in Advance Venu Muthaiah Chinnaveerappan (Muths), Systems Analyst, Chennai, India. Tel : 91-44-2435034 Email : [EMAIL PROTECTED]
Re: Drop schema and all related objects
Hi, Drop user user_name cascade; will drop the user including objects. Hope this helps, Muths At 05:40 AM 5/11/01 -0800, you wrote: >Hi DBA's, > >How can I drop schema (user and all it's objects). I have one main user in >the application and wants to drop user and all related objects. Can anyone >help me in this regard. >Thanks >Mujeeb Chowdhry >Oracle DBA > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Mujeeb Chowdhry > 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muthaiah 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: defragment ?
Hi, 1. Create a dummy table by using create table dummy_table as select * from original_table; 2. Truncate your original_table 3. insert into original_table select * from dummy_table; This will eliminate the fragmenataion Hope this helps, Regards, Muths At 11:40 PM 4/28/01 -0800, you wrote: >hi oracle gurus, >how can I defrag a table? >this table has many relations,I was going to drop them and export the table >and import it again,then create the relations. >this is very tedious! >is their any better way? > > > > > stuck with fragmented tables > > >Get free email and a permanent address at http://www.netaddress.com/?N=1 >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: MOHAMMAD AMER > 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muthaiah 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: ORA-12560 TNS: protocol adapter error
Hi, You have to set the oracle_sid in the path and the sid_name in the value in the environment tab of my computer. Once you set this you won't get the error. Alternatively you can set the same in the registry as well. Hope this helps, Muthaiah At 03:30 PM 4/23/01 -0800, you wrote: >Hi there! > >I am on a brandnew box with a brandnew Win2k Server installed on it. Then I >run the Oracle 8.1.6 installer and then try to create a database (i.e. use >my batch and SQL files). > >When I log into SQLPLUS as internal/oracle, I get an > >ORA-12560 TNS: protocol adapter error. > >Any idea why? The listener is up and running. > >Thanks, >Helmut > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Helmut Daiminger > 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muthaiah 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).
