imp for rank [message #71379] |
Thu, 24 October 2002 12:13 |
Edwin Villalta
Messages: 1 Registered: October 2002
|
Junior Member |
|
|
How make imp data last 3 moths to development database.
There is some application to make imp special.
Thanks
|
|
|
Re: imp for rank [message #71394 is a reply to message #71379] |
Sun, 27 October 2002 22:00 |
Trifon Anguelov
Messages: 514 Registered: June 2002
|
Senior Member |
|
|
Unless, you have time stamps in each of your tables, that would be hard to do. When having time stamps, just create db link to the development db on the production db, and use:
INSERT INTO devel_schema.table@db_link SELECT * FROM prod_schema.table;
Also If your data is partitioned, the above method will work when you specify the partition name.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|