Exp-Imp for object from one schema to another
536473Apr 17 2007 — edited Nov 21 2008What exactly privilege required to import the object in another schema? I have taken the export in another schema as owner of the object but wish to import in anither schema.
1) Do I need to cobbect with as sysdba?
2) Do i require exp_full_database and imp_full_database privilege?
Please note that I do not have the privilege to connect it as sysdba.