IMPORT Error - IMP-00020: long column too large for column buffer size

Hi list, i have Import error with Oracle 8.0.5 on HP-UX raoul B.11.00 A 9000/800. The folling tables Import terminated successfully AGG_CTR_SEDE_TRG_R V_DOC_AGREE_CTR_R but : . . importing table "AGG_CTR_SEDE_TRG_R" IMP-00020: long column too large for column buffer size

RE: 8i - Seeing which columns disabled

Hi, Tracey, From my own test, I remember data in a column set unused can still be dumped to a trace file. Depending on your knowledge of interpreting datafile dump, you can get the result back one row at a time (or even write a script to automate it; nobody outside Oracle can say that's easy).

805 client, 815 server ??

Hi all, I reinstalled 805 client with Database Administration option. When I used 805's sqlplus, svrmgrl to connect to a 815 database, I got this: ORA-12705: invalid or unknown NLS parameter value specified Any idea? Thanks a lot. Leslie __

RE: NT Server very slow

cant find it -Original Message- From: Jerry C [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 4:31 PM To: Multiple recipients of list ORACLE-L Subject: Re: NT Server very slow check out Doc ID 941798 at Metalink... - Original Message - To: [EMAIL

RE: Single Code Table or Separate Code tables dilemma

Title: RE: Single Code Table or Separate Code tables dilemma I'm still not quite sure I understand the single code table business. Let me give an example (taken from a live example at one of my previous jobs). I have a table called DOCTOR that has two fields - SPECIALTY and TYPE. The

RE: Single Code Table or Separate Code tables dilemma

CREATE TABLE I_DONT_LIKE_MASTER ( CODE_TYPE VARCHAR2(4) NOT NULL, CODE_VALUE VARCHAR2(3) NOT NULL, CODE_DESC VARCHAR2(20) , PRIMARY KEY (CODE_TYPE, CODE_VALUE) ) SPLTN SDFLJDSL SPLTFP SDFSDKFDS SPLTOBG SFLSDJFSD TYPEMD SDFLSDFSDF TYPEFP SDFJDSFJ TYPE

Unix question

Hi geeks , How can I do substr and instr kind of operaion in unix shell script . is it possible ? like i have one paramter as "hostname" .. I want to trim quotes surrounding the hostname . One more question , is possible to read another text file line by line using a shel script and then

RE: IMPORT Error - IMP-00020: long column too large for column bu

Title: RE: IMPORT Error - IMP-00020: long column too large for column buffer size -Original Message- From: Antonio Idone [mailto:[EMAIL PROTECTED]] i have Import error with Oracle 8.0.5 on HP-UX raoul B.11.00 A 9000/800. The folling tables Import terminated successfully

RE: how to store orace errors in database (UNIX scripting challen

Guys how about creating a shell script #/bin/ksh count=1 while [ $count -ne 10 ] do oerr ora $count count="$(($count + 1))" done 00088, 0, "command cannot be executed by MTS server " // *Cause: Debug command issued on MTS server. // *Action: Reissue the command using a

Re: Unix question

Yes no. There are a couple of different way to solve the problem. 1) Write your own functions/filters to accomplish the desired operations 2) If the only place in the file where double quote marks exists are around the hostname and all you want to do is get rid of them, the "tr" command could

syntax for trigger

Hi all, How to find out the whole syntax for a trigger? The dba/all/user_source view don't have text for trigger. The trigger_body column in All_triggers view doesn't show all the syntax. Thanks a lot. Andrea __ Do You Yahoo!? Get email at

Re: Unix question

No No . Here is full problem I have this ini file called xyz.ini having hostname = $HOSTNAME$.acme.com schemaname=$SCHEMANAME$ domainname= $HOSTNAME$.foo.bar.com okay , Now I am getting the values of hosname as "abc" , schema name as "schem" . I want to write a script in which I will

Re: Crontab - Ooops

Charlie, Some days are like that. You're right. Mike Hand had the right idea when he wrote: .. 2 choices are MM HH 22-28 * * (shell script checks for Sunday before proceeding) OR MM HH * * 0 (shell script checks for day of month between 22 and 28 before proceeding) Mike

<    1   2