This discussion is archived
2 Replies Latest reply: Sep 20, 2013 8:34 AM by 592815 RSS

issue about generated an offline SQL server 2008 data source by Oracle SQL developer

592815 Newbie
Currently Being Moderated

Hi Friends,


I followed tutor at Migrating a Microsoft SQL Server Database to Oracle Database 11g by sql developer  Version in window.

I can migrates sample codes into oracle database.  The example code have two folder:Capture and data. Under data folder, there are two parts. one is named as oracle sub folder and rest is data add log files.

When I migrated my 2008 sql server database into oracle 11. I can only migrated sql objects into oracle but failed loading data during missing data file.

Per reviewing, in output directory, I see lots of  ctl files under datamove folder and generate folder. But i am not able to find any data file to support ctl codes


The ctl file code example as

load data

infile 'data/'

"str '<EORD>'"

into table /


Due to missing data file, data loading works but not data in migrated tables.

recode show as



Table altered.


Trigger altered.

SQL> Disconnected from Oracle Database 12c Enterprise Edition Release - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options




Please help me where do I lost in migration that I can generate a data file during migration





  • Correct Answers - 10 points
  • Helpful Answers - 5 points