Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Import .dmp file into new schema?

805401Oct 14 2010 — edited Oct 16 2010

Hi folks,

I have a .dmp file which contains all the data of a table sat for example DEPT(S.No,FirstName,Salary,Address).
I created new schema as DEPT(S.No,FirstName,LastName,Address).

Now, how can I have all the corresponding fields data from old schema to the new schema?
By the way I'm using Oracle 10g Expression Edition.

Thanks,
Ashok Gunasani.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 13 2010

Added on Oct 14 2010

#database-key-features, #export-import-sql-loader-external-tables

5 comments

4,472 views