Home » RDBMS Server » Backup & Recovery » storing data in a file
storing data in a file [message #163219] Wed, 15 March 2006 09:59 Go to next message
orcl dba
Messages: 68
Registered: August 2005
Member
Hi all,

Is there any way we can store the data from an Oracle database in a file so that it can be read at a later time?

Thank you
Re: storing data in a file [message #163223 is a reply to message #163219] Wed, 15 March 2006 10:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You mean, storing as a text file?
You can spool the data or use UTL_FILE to write to a text file.
Re: storing data in a file [message #163323 is a reply to message #163223] Thu, 16 March 2006 03:53 Go to previous messageGo to next message
orcl dba
Messages: 68
Registered: August 2005
Member
Basically, I am looking to store the data in my database into a file(could be a text file or any other file). Data has to be stored very frequently into the files. Is there any way of doing this other than using PL/SQL packages?
Re: storing data in a file [message #163341 is a reply to message #163323] Thu, 16 March 2006 05:48 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Search for UTL_FILE
Re: storing data in a file [message #163377 is a reply to message #163219] Thu, 16 March 2006 08:41 Go to previous messageGo to next message
croK
Messages: 170
Registered: April 2002
Senior Member
Why simply use EXP to export individual tables, an entire schema with all tables o just the entire database.
Re: storing data in a file [message #163933 is a reply to message #163377] Mon, 20 March 2006 19:40 Go to previous message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
croK wrote on Thu, 16 March 2006 08:41

Why simply use EXP to export individual tables, an entire schema with all tables o just the entire database.


Good idea!

Alex zeng | Skype me: hans9zeng
Previous Topic: Oracle 7.3 missing data file
Next Topic: Cold backup Restore Query
Goto Forum:
  


Current Time: Sat Apr 20 03:03:11 CDT 2024