Re: imp full=Y ... create users?

Re: imp full=Y ... create users?

 

  

Hi

Which Username/Password you are specifying while creating the imp.

If you are using some ordinary <user-name> than all the objects realed to
that user is imported and if you are using sys than all the datadictinary
and all the schema and their objects are imported.

Thanks

Jai




"Castelletti Paolo "
<oracledba-ezmlmshield-x77086178.[Email address protected]
04/04/2007 04:14 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
imp full=Y ... create users?






Hi all,

I have a doubt: I need to perform an "imp full=Y" on ora
9.2.5... do I need to create users before doing this or users will be
imported along with SYSTEM?



Thanks in advance,

Paolo Castelletti



--------------------------------------------------------

This e-mail and any attachments is a confidential correspondence intended
only for use of the individual or entity named above. If you are not the
intended recipient or the agent responsible for delivering the message to
the intended recipient, you are hereby notified that any disclosure,
distribution or copying of this communication is strictly prohibited. If
you have received this communication in error, please notify the error at
the following email address: [Email address protected] or at Aspasiel
Helpdesk Team by phone (phone number +390744203555), and then delete this
message from your system.
--------------------------------------------------------


---------------------------------------------------------------------
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




"This E-Mail contains Confidential and/or legally privileged Information solely meant for the intended recipient(s) only. If you receive this e-mail in error and are not the intended recipient/s, kindly notify us at [Email address protected] (hypothetical mail id) and delete this e-mail immediately from your system. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail, its contents or its attachment/s either wholly or partially, other than by its intended recipient/s is strictly prohibited and is warned to be unlawful.

Internet Communications cannot be guaranteed to be secure or error-free as information could be delayed, intercepted, corrupted, lost, or contain viruses. Centurion Bank of Punjab Limited therefore shall not be liable for any errors, omissions, viruses or computer problems experienced by any recipient as a result of this e-mail."

Oracle LazyDBA home page