And also one more possibility is there,
With out permission you can't import from alm user.
So, grant DBA permission to alm user and then login in to alm user try to
import.
Completing of the import revoke the permission fro alm user.
Regards
Nagendra
-----Original Message-----
From: Vaishali Kamdar
[mailto:oracledba-ezmlmshield-x68258315.[Email address protected]
Sent: Wednesday, November 28, 2007 4:27 PM
To: LazyDBA Discussion
Subject: RE: import tables from one user to another
While importing login as alm and then try to import.
Regds,
Vaishali.
-----Original Message-----
From: Shadab Mehboob
[mailto:oracledba-ezmlmshield-x82821092.[Email address protected]
Sent: Wednesday, November 28, 2007 4:18 PM
To: LazyDBA Discussion
Subject: Re: import tables from one user to another
i used the from user = system touser=alm but teh problem still occurs
Regards
Shadab
----- Original Message -----
From: "Shadab Mehboob "
<oracledba-ezmlmshield-x30357256.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, November 28, 2007 4:09 PM
Subject: import tables from one user to another
> Dear Masters
> I imported all tables from one database through user "SYSTEM" and then
i
> imported these tables into another database into a user "ALM" but
these
> tables are still owned by user SYSTEM in the new database , how do i
make
> these tables owned bu ALM in the new database
> Kindly help
> Regards
> Shadab
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
----------------------------------------------------------------------
DISCLAIMER
This email and any files transmitted with it are confidential and are solely
for the use of the individual or entity to which it is addressed. Any use,
distribution, copying or disclosure by any other person is strictly
prohibited. If you receive this transmission in error, please notify the
sender by reply email and then destroy the message. Opinions, conclusions
and other information in this message that do not relate to official
business of the company shall be understood to be neither given nor endorsed
by NIIT Ltd. or NIIT Technologies Ltd. Any information contained in this
email, when addressed to Clients is subject to the terms and conditions in
governing client contract.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page