Oracle Database Discussions

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!

BLOB importing with IMP

421629May 19 2004 — edited May 20 2004

Hello,

I am trying to import a database dump to another location. This exercise gives an error when importing the table containing BLOB column.

My original database was in tablespace 'R' and owned by user 'R'. Now I want to load it to tablespace 'M' owned by user 'M'. What I understand is that the loader (IMP) still tries to create table with a BLOB column in 'R' tablespace while I want it to be created in 'M'.

What is the solution to this problem?

Kindly reply asap.

-- Hamid

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 17 2004

Added on May 19 2004

#general-database-discussions

5 comments

778 views