Creating and Oracle 7 DB from an Oracle 8 DB

2001-06-06 Thread Tim Allen
Hi, Its a long and boring story but I have an Oracle8 database andI need to create anOracle 7 database from it to support one of our applications. The schema of the Oracle 8 db does not have any oo features and is, in theory, it functionally compatable with an Oracle 7 db. But I

Re: Creating and Oracle 7 DB from an Oracle 8 DB

2001-06-06 Thread Joseph S. Testa
why not run version 7 export against the oracle 8 database(its been more than 4 years since i've played with a 7 database). or am i missing something here? joe Tim Allen wrote: Hi, Its a long and boring story but I have an Oracle 8 database and I need to create an Oracle 7 database from

RE: Creating and Oracle 7 DB from an Oracle 8 DB

2001-06-06 Thread Mark Leith
]]On Behalf Of Tim AllenSent: Wednesday, June 06, 2001 10:06To: Multiple recipients of list ORACLE-LSubject: Creating and Oracle 7 DB from an Oracle 8 DB Hi, Its a long and boring story but I have an Oracle8 database andI need to create anOracle 7 database from it to support one

Re: Creating and Oracle 7 DB from an Oracle 8 DB

2001-06-06 Thread Jared Still
Tim, As SYS, run ?/rdbms/admin/catexp7.sql on the Oracle 8 database. You then use the Oracle 7 binary for exp to export data from your Oracle 8 database. You will then be able to import the resulting file into your version 7 database. Used it several times, works fine. Exports created with