How toimport .dmp file in lower version of oracle from
higher version ?
Answer Posted / shai
Here's the answer straight from the Oracle Utilities guide:
Example:
You can create an Oracle release 7 export file from an
Oracle8 database by running Oracle release 7 Export against
an Oracle8 server. To do so, however, the user SYS must
first run the CATEXP7.SQL script, which creates the export
views that make the database look, to Export, like an
Oracle release 7 database.
Note: An Oracle8 Export requires that the CATEXP.SQL script
is run against the database before performing the Export.
CATEXP.SQL is usually run automatically when the user SYS
runs CATALOG.SQL to create the necessary views.
CATEXP7.SQL, however, is not run automatically and must be
executed manually. CATEXP7.SQL and CATEXP.SQL can be run in
any order; after one of these scripts has been run, it need
not be run again.
So, in order to import the data from 8.0 into 7.3, you must
create the export dmp file using the Oracle 7 release of
Export. Then when you use the Oracle 7 release of Import it
will understand the contents of the dmp file. If you tried
to just export from your 8.0 version and directly import
that using 7, it would fail.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what are the advantages of using stored procedures? : Sql dba
what is myisam? : Sql dba
how to drop an existing table in mysql? : Sql dba
Which sql statement is used to delete data from a database?
What is application trigger?
Which are sql * plus commands?
What is the difference between mdf and ndf files?
How do I make my sql query run faster?
What is the basic structure of an sql?
What is %rowtype in pl sql?
Can a key be both primary and foreign?
What are the different tcl commands in sql?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What is rank function in sql?
Is progress software supports to ( pl/sql )?