Home » RDBMS Server » Server Utilities » Importing other schema's object (Oracle 9i.2, Windows. )
Importing other schema's object [message #475887] Sun, 19 September 2010 00:21 Go to next message
muktha_22
Messages: 356
Registered: December 2009
Senior Member
Hi,

I have 2 users (scott and Krishnan).

Krishnan wants to import the table, which was exported by scott.

1) but we should not run the script file of CATALOG.SQL.
2) we can't give the rights of imp_full_database from outside.

Also how user Krishnan can import that table to another user's schema?

please advice me

Thanks a lot
Re: Importing other schema's object [message #475888 is a reply to message #475887] Sun, 19 September 2010 00:28 Go to previous messageGo to next message
muktha_22
Messages: 356
Registered: December 2009
Senior Member
Hi all,

I found the answer.

1) It is just need to specify TOUSER: KRISHNAN

2) But how to import that table into another schema. As we shouldn't run the script file again?

Thanks in advance.
Re: Importing other schema's object [message #475889 is a reply to message #475888] Sun, 19 September 2010 00:49 Go to previous messageGo to next message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the relation between the script and an import into another schema?

Regards
Michel
Re: Importing other schema's object [message #475890 is a reply to message #475888] Sun, 19 September 2010 00:52 Go to previous message
BlackSwan
Messages: 21948
Registered: January 2009
Senior Member
>As we shouldn't run the script file again?
Which script that contains what?
Previous Topic: Conflicting in parameters of export
Next Topic: need help with importing packages/triggers/functions
Goto Forum:
  


Current Time: Sat Apr 19 13:07:56 CDT 2014

Total time taken to generate the page: 0.08246 seconds