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: 527
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: 527
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: 68625
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: 26766
Registered: January 2009
Location: SoCal
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: Fri Mar 29 10:46:46 CDT 2024