sql - Missing select keyword from exported Oracle View DDL -

i'm having difficulties exporting / , importing database using impdm, , expdp.

i have valid schema, couple of working views created using statements similar to:

create or replace force view someview (column1, column2, etc) select column1, column2, etc sometable; 

i can query views no problem, , valid results:

select * someview; 

however if try export ddl views, using expdp, or simple dbms_metadata.get_ddl query. i.e.:

select dbms_metadata.get_ddl('view','someview','someschema') dual 

... of view ddls missing select keyword. instead of getting original ddl used create view in first place, like:

create or replace force view someview (column1, column3, etc) column1, column2, etcfrom sometable; 

this preventing me doing image export / imports on import step things blow on:

ora-39083: object type view failed create error: ora-00928:missing select keyword

suggestions?

i'm using oracle 11.2 on windows.

here work around might work you, if want export view script (select statement only) can access view code system table user_views (assuming have access it. script view under column text here sample query

select view_name,text user_views 

after select statement simple string manupilation , append create or replace ... syntax

i find these system tables useful