| Querying flat files [message #218719] |
Fri, 09 February 2007 09:47  |
agostino_neto
Messages: 180
Registered: July 2005
|
Senior Member |
|
|
Hi all,
I am looking for a solution to archive data into flat files and them available as if they were still in the database.
I taught external table was a good solution.
We don't need to store data in the database and we can always query our data using the same reports...
The problem is we can not create index for example.
Do some of you have a better solution to suggest?
Thanks
|
|
|
|
| Re: Querying flat files [message #218722 is a reply to message #218719] |
Fri, 09 February 2007 09:57  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>> archive data into flat files
I do not prefer this solution.
Archiving is something you want to preserve the data in its 'original' state.
It would be easier to take a backup and archive it off (partition/tablespaces whatever it is) and
maintain the archives through the upgrades.
If you still prefer to get the data out of oracle database, you need to live the consequences (pain with
loading them again,maintenance).
External tables are very good with an ETL standpoint view (offering a read-only view sort of thing).
So if you want to query them (through indexes), insert into a regular table and create indexes.
Regards~
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
