converting sco oracle to text file
![](https://seccdn.libravatar.org/avatar/d42b908138545ad2c25507327dedead4.jpg?s=120&d=mm&r=g)
Hi, I have a question concerning the way to turn an oracle 7.3.3.4 on sco db into a simple file on a linux box in order to turn it into an open source db... As I don't know how oracle run, i'd like to know if there's a simple way to do this. the original db sizes around 1Gb (for the whole files, but as it is oracle, i don't know if the db is really this big...). TIA for all the tracks that can be helpfull Regards Stephane
![](https://seccdn.libravatar.org/avatar/22d60ad58ee33e40858abc621f283468.jpg?s=120&d=mm&r=g)
You need to find the original build scripts... or find a utility that will generate the DDL (data definition language for you) do a search for DDL and see if you can find a free utility. I think there was one called TOAD I use SQL navigator to do this Im sure if you search around you'll find something, maybe a trial ware for SQL nav quest software... also you may want to search in the target machine for init.ora, this may help you identifying the tablespaces etc you can aslo search for all .sql scripts then look for 2 sql scrits . One will build the tablespaces the other the tables hth rob stephane parenton wrote:
Hi, I have a question concerning the way to turn an oracle 7.3.3.4 on sco db into a simple file on a linux box in order to turn it into an open source db... As I don't know how oracle run, i'd like to know if there's a simple way to do this.
the original db sizes around 1Gb (for the whole files, but as it is oracle, i don't know if the db is really this big...).
TIA for all the tracks that can be helpfull
Regards Stephane
-- To unsubscribe send e-mail to suse-linux-e-unsubscribe@suse.com For additional commands send e-mail to suse-linux-e-help@suse.com Also check the FAQ at http://www.suse.com/support/faq and the archives at http://lists.suse.com
participants (2)
-
dizzy
-
stephane parenton