Hi,
First you should assure you have exported 1) Database dump or 2)
USER dump.

IF you have exported Database dump then you don't need to give user name ,It
will automatically import whole database.
ELSE
If you have exported user dump you must provide the user name<'ALM'>
to be export at the time of Export and you have to create a user <ALM> in
new database then only you can give fromuser='ALM' touser='ALM'
END IF;


Regards,
Bimal



-----Original Message-----
From: Shadab Mehboob
[mailto:oracledba-ezmlmshield-x82821092.[Email address protected]
Sent: Wednesday, November 28, 2007 4:33 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





Oracle LazyDBA home page