Re: Any woraround for this ....?

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

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

Re: Any woraround for this ....?

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, Se

OCP-Network Exam

_ 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

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 DBOracle 8.1.6 EE Designer6i Developer 6i As suggested in the release notes of Designer, I have first installed the Designer in

Is CKPT process is Mandatory in 8i

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

Partly OT: Developer seeks job

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

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

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: 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

Re: Drop schema and all related objects

://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

Re: defragment ?

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

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