No replies
5 Posts

Pinned topic How to query archive files using views

‏2014-06-30T14:06:28Z |

I have customer situation where they like to archive 15 TB database. However they like to access this data through application views.

e.g. we have table1 and table2 consisting of 100 and 200 rows respectively. And there are 10 different views which is based on these tables. It make no sense to archive data underlying these 10 views as that will create duplicate data archive.

So If we archive table1 & table2 and archive views DDL only(only possible through extract ?) . However if we use Optim connect or any other tool like AQT- it will fetch zero rows if I run query on views (as it will take this standalone object ).

Would appreciate reply.