Import data with sql query result
508998Nov 7 2007 — edited Nov 7 2007Hi all,
As per my requirement i need to take query result set data from production databse and import that result set data into the development database(for testing purpose). We don't have any database links between them.
The query looks like
SELECT FROM MS.CUSTOMER, MS.ADDRESS_EMAIL
WHERE NXT_AUTO_REPLEN_DT < SYSDATE + 14
AND CUST_TYP_IND IN ('E', 'S')
AND FK_CUST_ID = CUST_ID
AND ADDR_TYP_CD = 'ST'
AND EMAIL IS NOT NULL
AND (0 =
(SELECT COUNT(*) FROM MS.CUSTOMER_PROCESS WHERE FK_CUST_ID = CUST_ID) OR
0 < (SELECT COUNT(*)
FROM MS.CUSTOMER_PROCESS
WHERE FK_CUST_ID = CUST_ID
AND LAST_EMAIL_DT + 14 < NXT_AUTO_REPLEN_DT))
and cust_id IN
(SELECT CUST_ID
FROM MS.CUSTOMER, ms.ADDRESS_EMAIL
WHERE NXT_AUTO_REPLEN_DT < SYSDATE + 14
AND CUST_TYP_IND IN ('E', 'S')
AND FK_CUST_ID = CUST_ID
AND ADDR_TYP_CD = 'ST'
AND EMAIL IS NOT NULL
AND (0 = (SELECT COUNT(*)
FROM ms.CUSTOMER_PROCESS
WHERE FK_CUST_ID = CUST_ID) OR
0 < (SELECT COUNT(*)
FROM ms.CUSTOMER_PROCESS
WHERE FK_CUST_ID = CUST_ID
AND sysdate + 14 < NXT_AUTO_REPLEN_DT)))
--GROUP BY NXT_AUTO_REPLEN_DT ORDER BY NXT_AUTO_REPLEN_DT DESC
and rownum < = 1000;
The above query will fetch 1000 rows that data need to be import on development server. Plesae guide me what way i need to follow to achieve this target. Thanks in Advace ............