OraFAQ Forum: Server Utilities » Loading data from star schema into a flat file

Home » RDBMS Server » Server Utilities » Loading data from star schema into a flat file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Loading data from star schema into a flat file [message #368421]

Mon, 18 December 2000 10:38

meena
Messages: 36
Registered: December 2000

Member

Hi,

I have a star schema with data in it. How can I load this data into a flat file?

Thanks!
Meena

Report message to a moderator

Re: Loading data from star schema into a flat file [message #368422 is a reply to message #368421]

Mon, 18 December 2000 12:32

Bala
Messages: 205
Registered: November 1999

Senior Member

Hi,

Basically you have to run sql query and spool the output.
Like
Select col1||','||col2||','||.....from t1;

spool the output, and you will have a csv file with all the data from t1. Like wise you have to do it for all the tables.
You can develop a master script to do unload the whole schema....if you don't have one...go to this site....
http://osi.oracle.com/~tkyte/flat/index.html

Report message to a moderator

Previous Topic:	Oracle Data Storage
Next Topic:	Re: Database size

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 04:05:05 CDT 2024