| Oracle 11g R2 [message #609817] |
Wed, 12 March 2014 12:53  |
oradba123
Messages: 86
Registered: June 2009
Location: india
|
Member |
|
|
Hi folks,
i have 2 tables named F571226, F751226_10march in two different schema testdta, backupdta respectively
Note: F571226 doesnt have any data in testdta schema, both have same columns names
Now my requirement is to insert data into F571226 from F571226_10march
but when i try to insert by below command it taking too time and failed
insert /*+ APPEND PARALLEL*/ into testdta.F571226 value select * from backupdta.F571226_10march14
shall i specify each field (columns name) instead of specifying source table (backupdta.F571226_10march) in the above syntax?. source table has got around 25000000 rows
please correct my syntax if it is wrong
insert /*+ APPEND PARALLEL */ nologging into testdta.F571226 value select col1, col2,col3,col4,col5 ................... from backupdta.F571226_10march.
thanks & regards
|
|
|
|
|
|
|
|
| Re: Oracle 11g R2 [message #609853 is a reply to message #609851] |
Thu, 13 March 2014 03:56  |
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
|
Senior Member |
|
|
You didn't format your code, as requested by BlackSwan, to make it easier to read:
INSERT /*+ APPEND */ INTO testdta.f571226
SELECT /*+ APPEND */ *
FROM backupdta.f571226_10march14
If you want others to help you, you must also help them.
HTH
-g
|
|
|
|
| Re: Oracle 11g R2 [message #609856 is a reply to message #609851] |
Thu, 13 March 2014 04:07 |
 |
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
APPEND hint on SELECT is useless (ignored as irrelevant); you could use PARALLEL or PARALLEL(x) instead if your hardware and concurrent workload allow it.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
