How to import a file exported by DBA user. [message #34668] |
Mon, 27 December 2004 18:13 |
Santosh Kaduskar
Messages: 44 Registered: October 2004
|
Member |
|
|
Hi,
is it possible to import a file exported by DBA user.
as currently we want to import file in non dba user in client side.while we are creating export file on server. is there any option as we dont want to give IMP_FULL_DATABASE option to client user.
Urgeant.
Santosh.
|
|
|
|
|
|
Re: How to import a file exported by DBA user. [message #34684 is a reply to message #34683] |
Tue, 28 December 2004 02:41 |
Santosh Kaduskar
Messages: 44 Registered: October 2004
|
Member |
|
|
Our client is at UK.i want to send export of some table to client on monthly basis.as i am exporting the tables by BDA user its unable to import client site giving the error "exported by some other user" that means file exported by DBA user local user canot import it. but i dont want to give IMP_FULL_DATA rights to my clients.
How should i solve this prob.
Its very urgeant.
Santosh.
|
|
|
|
Re: How to import a file exported by DBA user. [message #34698 is a reply to message #34685] |
Tue, 28 December 2004 19:11 |
Santosh Kaduskar
Messages: 44 Registered: October 2004
|
Member |
|
|
Thanks...
u mean i have to create new user having operator rights
its fine but table size is very big hence i cannot recreate the table in this user.
so is there any option i can take table from DBA user and export by operator user.
how i can proced for this...is there any option.
Urgeant...
Santosh.
|
|
|
Re: How to import a file exported by DBA user. [message #34744 is a reply to message #34698] |
Thu, 30 December 2004 04:05 |
William Robertson
Messages: 1643 Registered: August 2003 Location: London, UK
|
Senior Member |
|
|
No, Anil's suggestion is to create a user account at your site with no objects, but with permissions that allow it to query/export the required tables from other schemas. Then you send that export file to the client site and they should be OK. I haven't tested this myself but it sounds worth a try.
|
|
|