Skip to Main Content
Forums

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!

expdp/exp without clob column

N_RajSep 12 2016 — edited Sep 14 2016

Hi All,

We have oracle 11.2 on Redhat 6.

we have a table which has clob datatype.Size of table is 200 GB including CLOB. Without clob size is 25GB only.

We want to take expdp/exp without clob datatype/column for that table.

We have expdp /exp privilege only.We don't have table creation privilege in the schema. Hence we can't use create table test_clob1 as select  col1,col2 from clob;

Any suggestions

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 12 2016
Added on Sep 12 2016
#database-key-features, #export-import-sql-loader-external-tables
3 comments
2,193 views