Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> exp - imp problem
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFEC8B.9BB90460
Content-Type: text/plain
Hi all,
I am having a full export of an database and now i need to import only a
perticular user's schema from that dump.I droped the user before import with
out looking at the roles that are granted to that user.Now after recreatng
that user i am clueless that what kind of roles that user got.
Will my import fail if i just give connect and resource to that new user and perform import?
Thanks,
Uma Shankar
------_=_NextPart_001_01BFEC8B.9BB90460
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>exp - imp problem</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2 FACE=3D"Arial">Hi all,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">I am having a full export of an =
database and now i need to import only a perticular user's schema from =
that dump.I droped the user before import with out looking at the roles =
that are granted to that user.Now after recreatng that user i am =
clueless that what kind of roles that user got.</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Will my import fail if i just give =
connect and resource to that new user and perform import?</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Uma Shankar</FONT>
</P>
<BR>
</BODY>
Received on Thu Jul 13 2000 - 00:31:29 CDT
![]() |
![]() |