Database Utilities (MOSC)

MOSC Banner

load data by creating tables

edited Oct 13, 2017 5:01AM in Database Utilities (MOSC) 2 commentsAnswered

I have over 50,000 files  let say

tyep1. co1,co2,co3,co4 etc number of files 10,000

           int, int, char, int

some of files has header only and details are blank

type2:  co1,co2,co3,co4 etc number of files 30,000

          char,char,init,date,date, etc

over 50 table types.

create a table for each table type on oracle is  time consuming . each text files  has lot of columns. Any how to load the data to oracle by creating table with understanding data type  based on  text file.

Appreciate any feedback. 

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