This content has been marked as final. Show 5 replies
user10450258 wrote:create table schema2.table_name as select * from schema1.view_name ? with appropriate privileges, it is as simple as that.
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 ?
This is not something that is currently available in Data Pump. Data Pump has been asked to support this, but as of 18.104.22.168, this is not available. If this is something you need done by your customer, then the best solution would be to create another table with the data that you need and then export that table, then drop the table.
You can sort of do it with external tables which wouldn't involve actually creating an additional normal table inside the database but still isn't exactly what you want - have a look at the external table example in the link below:
I thought you may be able to load the created dumpfile directly into another database using impdp but that doesn;t seem to be allowed - i guess some of the metadata etc is not generated.