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!

IMP-00017: following statement failed with ORACLE error 1276

centerBFeb 4 2011 — edited Feb 4 2011

i have exported the full database without rows from live database and tried to import it into training database.
both use ASM file system.i have precreated tablespace in training database.
but im getting the error IMP-00017: following statement failed with ORACLE error 1276.

it tries to create tablesapce and datafile on live ASM location rather than creating it on training database ASM location.
live database asm location is WEBD and training database is at TRAIND.
it tries to import on WEBD RATHER THAN TRAIND and throws the error.
any help is appreciated.i have googled it and cant find anything helpful.
Im bit new to DBA stuff.
is there anyway to import and export data in ASM file system?
Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 4 2011

Added on Feb 4 2011

#database-key-features, #export, #export-import-sql-loader-external-tables, #import

3 comments

587 views