Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: [Q] data createion question on NT?

Re: [Q] data createion question on NT?

From: L <leed_at_chele.cais.net>
Date: Tue, 19 Dec 2000 19:50:30 -0500 (EST)
Message-Id: <10715.124976@fatcity.com>


I understand that. Actually, I have been doing "catexp7.sql" on SUn SOlaris several times to export DB to another ORACLE 7 computer. On SUn if you doing "catexp7.sql", after finish you need immediate run "catexp8" to change the view back. Otherwise your ORACLE 8 export will have problem. My question is why " ORACLE put this catexp7 on scripts"? Because most people won't export DB to ORACLE 7.

On Tue, 19 Dec 2000, pknorr wrote:

> I recall running the catexp7.sql script on an 8 database to enable me to export
> from that Oracle 8 database and then import the object into a 7.3 database.
>
> L wrote:
>
> > We have ORACLE 8.1.6 on NT 4.0. I use "ORACLE DB assistance" to generate
> > create DB scripts. on file "dbXXXrun1.sql", their has following entrys:
> >
> > @d:\oracle\ora81\rdbms\admin\catalog.sql
> > @d:\oracle\ora81\rdbms\admin\catexp7.sql
> > @d:\oracle\ora81\rdbms\admin\catproc.sql
> >
> > Why is "catexp7.sql" in their? Is it require for ORACLE 8.1.6 to create
> > DB?
> >
> > Thanks
> >
> > --------
> > Think you know someone who can answer the above question? Forward it to them!
> > to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> > to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Received on Tue Dec 19 2000 - 18:50:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US