How toimport .dmp file in lower version of oracle from
higher version ?

Answer Posted / sanjay

We can use the exp utility which was introduced in oracle 7 to export and we can use the imp utility to import the data.Because oracle always support the lower versions in the higher version.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention what plvcmt and plvrb does in pl/sql?

633


how to get help information from the server? : Sql dba

526


Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

549


What is the difference between a query and a report?

513


What are character functions?

626






What is the difference between microsoft access and sql server?

527


Why are aggregate functions called so?

507


What is a join?

621


Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

612


What is embedded sql what are its advantages?

502


How to run sql*plus commands in sql developer?

585


Which are the different character-manipulation functions in sql?

543


What is cross join example?

549


Why do we need view in sql?

545


Why functions are used in sql?

512