Datapump import
Having created a nice new Oracle 11g database, I wanted to import one schema from a 10g db into it using the Datapump REMAP_SChema function. All worked well, until I realised that I hadn't limited the IMPORT to just that schema, was using a full export, and was importing as system. Most of the other schemas within the export pump failed (because I hadn't set up tablespaces for them) which is good - I've just got the schema I wanted (and a couple of small ones that won't matter) but I've realised that SYSTEMs and probably SYS' objects were also imported. Most