Home » RDBMS Server » Server Utilities » Querying flat files
Querying flat files [message #218719] Fri, 09 February 2007 09:47 Go to next message
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?

Re: Querying flat files [message #218722 is a reply to message #218719] Fri, 09 February 2007 09:57 Go to previous message
Mahesh Rajendran
Messages: 10672
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.
Previous Topic: Getting error in data pump export
Next Topic: importing error
Goto Forum:

Current Time: Wed Oct 26 01:04:06 CDT 2016

Total time taken to generate the page: 0.08113 seconds