Technology Stack - EBS (MOSC)

MOSC Banner

How to default the datatype size for column referring in sql loader control file based on table colu

edited Mar 2, 2017 4:00AM in Technology Stack - EBS (MOSC) 1 commentAnswered

Hi ,

I need to know is there any way to default the datatype size for the column referring in sql loader control file based on the table column..

Ex ,,

I'm using a TABLE XX with column AA varchar2(300),BB varcahr2(50)

in control file instead of mentioning the value like

AA   char(300)  ,

...

Because , whenever i change the size of column in DB , i need to change the value in control file which needs manual effort to overcome this..

Is there anyway to default the size based on DB ..

Pls share your suggestions ..

Thanks,

Pavan

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center