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
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
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
_
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
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,
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
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
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
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."
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
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
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
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
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
14 matches
Mail list logo