Hi,

I am creating an export from a specific schema. This will be imported into another schema. Under normal circumstance, to do cross-schema imp/exp the user needs to have dba privs. Is there a way for me to create an export that another schema owner can import without having the need for that user to have dba privs?

The issue is that I am sending an import to an outsource to use. Obviously our schemas are different. I am sendign them a few tables to work on in their own db.


Any suggestions?

Thanks,

Hannah

(This is what I have right now - but they want to do it locally I guess)

MyDB
SchemaA (my schema)

TableA
TableB

SchemaB (user with privs to specific table in SchemaA)

Privs to TableA
Privs to TableB


TheirDB
SchemaB
TableA
TableB



Doing an export of their user wont work as the tables are owned by another schema altogether.

TIA
Oracle LazyDBA home page