| Archiving Data [message #64269] |
Fri, 07 January 2005 07:33  |
Sean
Messages: 22
Registered: July 2000
|
Junior Member |
|
|
Hi all,
How can one archive old data in a schema when many tables in the schema do not contain date field.
We are using Oracle 9iR2 on Sun
Thanks
|
|
|
|
| Re: Archiving Data [message #64289 is a reply to message #64269] |
Mon, 10 January 2005 03:43  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
You obviously cannot, unless you can join with tables with date columns!
Best would be to add date columns and start populating them. That will enable you to archive the data in future.
Best regards.
Frank
|
|
|
|
| Re: Archiving Data [message #64443 is a reply to message #64289] |
Sun, 30 January 2005 06:01 |
pat
Messages: 27
Registered: September 2000
|
Junior Member |
|
|
Frank,
Could you elaborate little bit more here, please? You need a date field in each table or schema to archive?
Thanks,
pat
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
