extracting schema only

Dev Shed Forums Sponsor:

September 27th, 2004, 02:44 AM

mariuz

Bug Hunter

Join Date: May 2003

Location: Transylvania (Romania)

Posts: 274

Time spent in forums: 20 h 12 m 34 sec
Reputation Power: 9

extracting schema only

how can i extract schema only , using the sqlplus ? and then dump tables (csv, or tab delimited)
ps:
i need a comand line tool
exp doesn't work (different oracle versions ) and no access to the machine only with oracle cmd line tools ....

__________________
My home page: http://www.firebirdsql.org and work place :http://www.reea.net

September 27th, 2004, 03:00 AM

pabloj

Modding: Oracle MsSQL Firebird

Dev Shed God 6th Plane (7500 - 7999 posts)

Join Date: Jun 2001

Location: Outside US

Posts: 7,917

Time spent in forums: 2 Months 3 Weeks 3 Days 15 h 7 m 10 sec
Reputation Power: 279

You should run the appropriate script, see

Quote:

Can one import/export between different versions of Oracle?
Different versions of the import utility is upwards compatible. This means that one can take an export file created from an old export version, and import it using a later version of the import utility. This is quite an effective way of upgrading a database from one release of Oracle to the next.

Oracle also ships some previous catexpX.sql scripts that can be executed as user SYS enabling older imp/exp versions to work (for backwards compatibility). For example, one can run $ORACLE_HOME/rdbms/admin/catexp7.sql on an Oracle 8 database to allow the Oracle 7.3 exp/imp utilities to run against an Oracle 8 database.

See http://www.orafaq.com/faqiexp.htm#USE
Which Oracle version are you using?

__________________
My blog
Tutorials about OSS databases, DBMonster ...
Contribute to OSS Development, fill bug reports!
Developer Shed eSupport
Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK)
An introduction to database normalization
Natural or Surrogate key
Custom ordering for your results
Correlated and uncorrelated subqueries
Don't turn your outer joins into inner joins
Random data (with a bias)

September 27th, 2004, 03:34 AM

mariuz

Bug Hunter

Join Date: May 2003

Location: Transylvania (Romania)

Posts: 274

Time spent in forums: 20 h 12 m 34 sec
Reputation Power: 9

It's oracle 9 tools connecting to 8

September 27th, 2004, 03:50 AM

pabloj

Modding: Oracle MsSQL Firebird

Join Date: Jun 2001

Location: Outside US

Posts: 7,917

Time spent in forums: 2 Months 3 Weeks 3 Days 15 h 7 m 10 sec
Reputation Power: 279

Can you connect to the database server with SSH/Telnet and use the tools there?

September 27th, 2004, 04:40 AM

mariuz

Bug Hunter

Join Date: May 2003

Location: Transylvania (Romania)

Posts: 274

Time spent in forums: 20 h 12 m 34 sec
Reputation Power: 9

no ssh/telnet access to that server

September 27th, 2004, 04:57 AM

pabloj

Modding: Oracle MsSQL Firebird

Join Date: Jun 2001

Location: Outside US

Posts: 7,917

Time spent in forums: 2 Months 3 Weeks 3 Days 15 h 7 m 10 sec
Reputation Power: 279

Well, extracting the schema seems hard, can't you download and install an Oracle 8 client from which take the utilities?

Exporting to csv files is easy, you can just run this in sqlplus:

Code:

spool tablename.csv
set termout off
set pagesize 0
set heading off
set feedback off
select field1||','||field2||','|| field3 from tablename; 
quit

TA-DA!!! ORAFAQ comes to help, see http://www.orafaq.com/scripts/sql/mktable.txt

Last edited by pabloj : September 27th, 2004 at 05:02 AM.

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: