Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> exp - imp problem

exp - imp problem

From: Uma Sankara_Sivadanam <UmaSankara_Sivadanam_at_satyam.com>
Date: Thu, 13 Jul 2000 11:01:29 +0530
Message-Id: <10556.111921@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US