Does Sql Loader create a table automatically .
874051Dec 16 2011 — edited Dec 16 2011Hi,
I have a few CSV files with nearly 250 fields. I need to export this data to a oracle table . We usually create a table similar to the file and then move the data to table using a control file . Here , Can oracle create a table itself ? I mean instead of we manually creating a table , Can oracle take care of this and creates table ?
If not , Please help me any other way I can accomplish this task in a minimal time.
select * from v$version
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Solaris: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
Thanks ,
Mahesh