Data pump import REMAP_SCHEMA option
I have a database 10g. it has theses 2 schemas in it each running its own instance of an application. so the application is called axium. the schema axium is running one instance of the application axium, then there is anouther schema called axiumfp that is running the same application. one group of people log into the application attached to the axium schema and another group of people log into the application attached to the axiumfp. I needed to create a third schema with the same table structure, so I exported the axiumfp then did an import using the REMAP_SCHEMA option to a new schema axiumr. everything was fine until my boss asked me to change the password to the same as one of the other schemas. once I did that you could not attach anything stored in the database as a blob.