var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Insert Query
Hello Gurus !
I am working on testing database and production database. I have table A_t in testing and table A_p in production database as well. Both have same structure.
Table A in testing database is empty.
Table A in production database has millions and millions of rows.
What I need to do is populate table A_t in testing database with the same data in table A_p in production database.
I am using a simple insert statement but its taking a hell lotta time.
INSERT INTO A_t
(SELECT * FROM <schema.A_p@database_link
WHERE date BETWEEN '01-FEB-04' AND '02-FEB-04');
Can I use a PL/SQL table instead and use bulk binding ... Is this recommended ??
Try to push the data, i stead of pulling.
INSERT INTO table_t@testdb
SELECT * from table_p
where date between ... and ...