-2

In my Developement Environment 

Employee Table 
ID, NUMBER (PK)
NAME VARCHAR2(20)
DP_ID NUMBER (FK)

In my Testing Environment 

Employee Table 
ID, NUMBER (PK)
NAME VARCHAR2(20)
DP_ID NUMBER (FK)

with same structure in my Developement Environment having 3,00000 record . now i want to insert 3,00000 in my Testing Environment in oracle .

Vinoth_S
  • 1,380
  • 1
  • 12
  • 15
  • I don't understand the question. Do you want to move all the data from dev to test? If so, a database link an an `INSERT SELECT` would work. So would exporting and importing. If you're asking something else, please clarify. – Justin Cave May 06 '15 at 22:37

1 Answers1

0

Here's an answer that may be of some use to you. Also if you're using any program to manage your data, e.g. PHPMyAdmin, they typically have an 'export data as sql statement' option for easy insertion.

Community
  • 1
  • 1
Adam Ashwal
  • 1,472
  • 1
  • 19
  • 36