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

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

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

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,

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

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

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

Re: defragment ?

scribing). _ 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-50

Re: Drop schema and all related objects

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 ac

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

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", lin

Re: Any woraround for this ....?

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

Re: Any woraround for this ....?

able 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