dbTalk Databases Forums  

ORA-01460 error

Go Back dbTalk Databases Forums Databases comp.databases.oracle.misc ORA-01460 error

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss ORA-01460 error in the comp.databases.oracle.misc forum.



Reply
Page 1 of 5 1 2 3 4 5 >
 
Thread Tools Display Modes
  #1  
Old   
blindsey
 
Posts: n/a

Default ORA-01460 error - 10-22-2008 , 12:35 PM





I'm trying to load images into an Oracle table using this technique:

http://www.dba-oracle.com/oracle_new...ges_tables.htm

SQLLDR is kicking back all rows with the error "ORA-01460:
unimplemented or unreasonable conversion requested."

Any ideas? How to get around/fix?

Reply With Quote
  #2  
Old   
blindsey
 
Posts: n/a

Default Re: ORA-01460 error - 10-22-2008 , 12:36 PM





On Oct 22, 1:35*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote:
Quote:
I'm trying to load images into an Oracle table using this technique:

http://www.dba-oracle.com/oracle_new...p_loading_imag...

SQLLDR is kicking back all rows with the error "ORA-01460:
unimplemented or unreasonable conversion requested."

Any ideas? *How to get around/fix?
It's Oracle 10.2.0.1.0, by the way.


Reply With Quote
  #3  
Old   
blindsey
 
Posts: n/a

Default Re: ORA-01460 error - 10-22-2008 , 12:36 PM


On Oct 22, 1:35*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote:
Quote:
I'm trying to load images into an Oracle table using this technique:

http://www.dba-oracle.com/oracle_new...p_loading_imag...

SQLLDR is kicking back all rows with the error "ORA-01460:
unimplemented or unreasonable conversion requested."

Any ideas? *How to get around/fix?
It's Oracle 10.2.0.1.0, by the way.


Reply With Quote
  #4  
Old   
blindsey
 
Posts: n/a

Default Re: ORA-01460 error - 10-22-2008 , 12:36 PM


On Oct 22, 1:35*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote:
Quote:
I'm trying to load images into an Oracle table using this technique:

http://www.dba-oracle.com/oracle_new...p_loading_imag...

SQLLDR is kicking back all rows with the error "ORA-01460:
unimplemented or unreasonable conversion requested."

Any ideas? *How to get around/fix?
It's Oracle 10.2.0.1.0, by the way.


Reply With Quote
  #5  
Old   
blindsey
 
Posts: n/a

Default Re: ORA-01460 error - 10-22-2008 , 12:36 PM


On Oct 22, 1:35*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote:
Quote:
I'm trying to load images into an Oracle table using this technique:

http://www.dba-oracle.com/oracle_new...p_loading_imag...

SQLLDR is kicking back all rows with the error "ORA-01460:
unimplemented or unreasonable conversion requested."

Any ideas? *How to get around/fix?
It's Oracle 10.2.0.1.0, by the way.


Reply With Quote
  #6  
Old   
Vladimir M. Zakharychev
 
Posts: n/a

Default Re: ORA-01460 error - 10-22-2008 , 01:08 PM


On Oct 22, 9:36*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote:
Quote:
On Oct 22, 1:35*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote:

I'm trying to load images into an Oracle table using this technique:

http://www.dba-oracle.com/oracle_new...p_loading_imag...

SQLLDR is kicking back all rows with the error "ORA-01460:
unimplemented or unreasonable conversion requested."

Any ideas? *How to get around/fix?

It's Oracle 10.2.0.1.0, by the way.
And your table DDL and SQL*Loader control file are...?

Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com


Reply With Quote
  #7  
Old   
Vladimir M. Zakharychev
 
Posts: n/a

Default Re: ORA-01460 error - 10-22-2008 , 01:08 PM


On Oct 22, 9:36*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote:
Quote:
On Oct 22, 1:35*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote:

I'm trying to load images into an Oracle table using this technique:

http://www.dba-oracle.com/oracle_new...p_loading_imag...

SQLLDR is kicking back all rows with the error "ORA-01460:
unimplemented or unreasonable conversion requested."

Any ideas? *How to get around/fix?

It's Oracle 10.2.0.1.0, by the way.
And your table DDL and SQL*Loader control file are...?

Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com


Reply With Quote
  #8  
Old   
Vladimir M. Zakharychev
 
Posts: n/a

Default Re: ORA-01460 error - 10-22-2008 , 01:08 PM


On Oct 22, 9:36*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote:
Quote:
On Oct 22, 1:35*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote:

I'm trying to load images into an Oracle table using this technique:

http://www.dba-oracle.com/oracle_new...p_loading_imag...

SQLLDR is kicking back all rows with the error "ORA-01460:
unimplemented or unreasonable conversion requested."

Any ideas? *How to get around/fix?

It's Oracle 10.2.0.1.0, by the way.
And your table DDL and SQL*Loader control file are...?

Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com


Reply With Quote
  #9  
Old   
Vladimir M. Zakharychev
 
Posts: n/a

Default Re: ORA-01460 error - 10-22-2008 , 01:08 PM


On Oct 22, 9:36*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote:
Quote:
On Oct 22, 1:35*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote:

I'm trying to load images into an Oracle table using this technique:

http://www.dba-oracle.com/oracle_new...p_loading_imag...

SQLLDR is kicking back all rows with the error "ORA-01460:
unimplemented or unreasonable conversion requested."

Any ideas? *How to get around/fix?

It's Oracle 10.2.0.1.0, by the way.
And your table DDL and SQL*Loader control file are...?

Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com


Reply With Quote
  #10  
Old   
blindsey
 
Posts: n/a

Default Re: ORA-01460 error - 10-22-2008 , 01:13 PM


On Oct 22, 2:08*pm, "Vladimir M. Zakharychev"
<vladimir.zakharyc... (AT) gmail (DOT) com> wrote:
Quote:
On Oct 22, 9:36*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote:

On Oct 22, 1:35*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote:

I'm trying to load images into an Oracle table using this technique:

http://www.dba-oracle.com/oracle_new...p_loading_imag....

SQLLDR is kicking back all rows with the error "ORA-01460:
unimplemented or unreasonable conversion requested."

Any ideas? *How to get around/fix?

It's Oracle 10.2.0.1.0, by the way.

And your table DDL and SQL*Loader control file are...?

Regards,
* *Vladimir M. Zakharychev
* *N-Networks, makers of Dynamic PSP(tm)
* *http://www.dynamicpsp.com
Exactly as in the linked example, except for the filenames, which are
jpgs instead of gifs. (and changing the second "file_id" to
"file_data", which is an obvious error).



Reply With Quote
Reply
Page 1 of 5 1 2 3 4 5 >

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top