oracle-databaseplsqloracle10gsql-loaderctl

SQLLDR and .ctl files


I have a ddl script to create some tables but the data is in .ctl files and I never use it before. I did some researches but I didn't quite understand how to use SQLLDR. How it works? Can I use some other way to execute the .ctl file? I'm just using PL/SQL and Oracle 10G


Solution

  • The way you put it, it would go like this:

    If everything is OK, data will be loaded. Check log files!