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 3.2.20.10 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/dbo_test.sale.dat'

"str '<EORD>'"

into table /dbo_test.sale.SALE

----

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

recode show as

......

SQL>

Table altered.

SQL>

Trigger altered.

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

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

 

C:\SQL_DB\SQL_OUT\testout\datamove\SQL_mig\2013-09-09_13-43-43\sale\dbo>

 

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

 

Thanks

newdaa

Legend

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