Skip to Main Content

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!

Export view and import to a table

mayuravirajjavaJan 7 2013 — edited Jan 7 2013
Hi all,

I want to export a view and import to a table in another scheme. Export data should be the data which is available at the creation of view. Import schema has a table which match this view and data should be imported to this table.
I tried using expdp and impdp. But impdp import as normal view ( data is different when selecting from this imported view ).
Is this possible ? If it is possible how to do this ?

Thanks,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 4 2013
Added on Jan 7 2013
5 comments
431 views