OraFAQ Forum: Server Utilities » Importing other schema's object

Home » RDBMS Server » Server Utilities » Importing other schema's object (Oracle 9i.2, Windows. )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Importing other schema's object [message #475887]

Sun, 19 September 2010 00:21

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

Report message to a moderator

Re: Importing other schema's object [message #475888 is a reply to message #475887]

Sun, 19 September 2010 00:28

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.

Report message to a moderator