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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: urgent.....error in droping a user .

RE: urgent.....error in droping a user .

From: Kevin Kostyszyn <kevin_at_dulcian.com>
Date: Fri, 5 Jan 2001 09:59:10 -0500
Message-Id: <10732.125834@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_009B_01C076FE.267DE710
Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

I am just catching the end of this, but don't you have to log in as sys, and then fire off a couple of scripts that create all of the necessary grants for the new user?
Kev
  -----Original Message-----
  From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of bunyamin karadeniz
  Sent: Friday, January 05, 2001 8:31 AM   To: Multiple recipients of list ORACLE-L   Subject: Re: urgent.....error in droping a user .

  While creating the repository , creating the user is the first step( the schema where the repository tables will be created in) . And user is created . I queried the dba_users, Every time creates the user but after it there comes the creating the repository and IT CAN NOT DO THAT. gives error in. MASCRE.sql is giving error according to details of error.

    YES I log in as system user.
  Before creating a repository , do I have to do something else.... I called oracle for support but they may be late..

                Thanks

  **********************************************
  Bunyamin K. Karadeniz
  Information Technologies Dept.
  Database Group Tel :90-312-2873565/1681   HAVELSAN Ankara / TURKEY

    Dear Mr. Bunyamin,

        Did you log in as system user and execute this command? If so and then also you are getting the error find out whether you have this user in the database by running the following query:

    Select username from dba_users;

    Hope this helps.

    Regards,

    Ranganath

      -----Original Message-----
      From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of bunyamin
karadeniz
      Sent: Wednesday, January 03, 2001 5:36 PM
      To: Multiple recipients of list ORACLE-L
      Subject: urgent.....error in droping a user .


      When I want to drop a user with some objects I can not do it. Here
below is the error.
      Can you help me=????????????**

      SQL> drop user mehmet cascade;
      drop user mehmet cascade
      *
      HATA satır 1:
      ORA-00604: tekrarlayan SQL 1 düzeyinde hata olu¿tu
      ORA-00942: tablo yada görüntü mevcut degil (table or view does not
exist)
      Bunyamin K. Karadeniz
      Information Technologies Dept.
      Database Group Tel :90-312-2873565/1681
      HAVELSAN Ankara / TURKEY
      **********************************************

------=_NextPart_000_009B_01C076FE.267DE710
Content-Type: text/html;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4207.2601" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#a6caf0>
<DIV><SPAN class=3D531315814-05012001><FONT face=3DArial color=3D#0000ff =
size=3D2>I am=20
just catching the end of this, but don't you have to log in as sys, and = then=20
fire off a couple of scripts that create all of the necessary grants for = the new=20
user?</FONT></SPAN></DIV>
<DIV><SPAN class=3D531315814-05012001><FONT face=3DArial color=3D#0000ff =

size=3D2>Kev</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">   <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT = face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com=20   [mailto:root_at_fatcity.com]<B>On Behalf Of </B>bunyamin=20   karadeniz<BR><B>Sent:</B> Friday, January 05, 2001 8:31 = AM<BR><B>To:</B>=20
  Multiple recipients of list ORACLE-L<BR><B>Subject:</B> Re: = urgent.....error=20
  in droping a user . <BR><BR></FONT></DIV>   <DIV><FONT face=3DArial size=3D2>While creating the repository , = creating the user=20
  is the first step( the schema where the repository tables will be = created in)=20
  . And user is created . I queried the dba_users, Every time creates = the user=20
  but&nbsp; after it there comes the creating the repository&nbsp; and = IT CAN=20
  NOT DO THAT. gives error in. MASCRE.sql is giving error according to = details=20
  of error. </FONT></DIV>

  <DIV><FONT face=3DArial size=3D2>&nbsp; YES I log in as system user. =
</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2>Before creating a repository , do I =
have to do=20
  something else.... I called oracle for support but they may be=20   late..</FONT></DIV>
  <DIV><FONT face=3DArial=20
  =
size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p;&nbsp;&nbsp;=20
  Thanks</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV>**********************************************<BR>Bunyamin K.=20
  Karadeniz<BR>Information Technologies Dept.<BR>Database Group Tel=20   :90-312-2873565/1681<BR>HAVELSAN Ankara /=20
  TURKEY<BR>**********************************************</DIV>
  <BLOCKQUOTE=20
  style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
    <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
    <DIV=20
    style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20

    <A title=3Dranganathk_at_lgsi.co.in=20
    href=3D"mailto:ranganathk_at_lgsi.co.in">ranganathk krishnaswamy</A> = </DIV>

    <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = title=3Dbunyamink_at_havelsan.com.tr=20

    =
href=3D"mailto:bunyamink_at_havelsan.com.tr">bunyamink_at_havelsan.com.tr</A> = </DIV>

    <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Friday, January 05, = 2001 4:16=20

    PM</DIV>
    <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> RE: urgent.....error = in=20

    droping a user . </DIV>
    <DIV><BR></DIV>
    <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20     class=3D763431413-05012001>Dear Mr. Bunyamin,</SPAN></FONT></DIV>     <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20     class=3D763431413-05012001></SPAN></FONT>&nbsp;</DIV>     <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20     class=3D763431413-05012001>&nbsp;&nbsp;&nbsp; Did you log in as = system user=20

    and execute this command?&nbsp; If so and then also you are getting = the=20

    error find out whether you have this user in the database by running = the=20

    following query:</SPAN></FONT></DIV>     <DIV>&nbsp;</DIV>
    <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20     class=3D763431413-05012001>Select username from = dba_users;</SPAN></FONT></DIV>

    <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20     class=3D763431413-05012001></SPAN></FONT>&nbsp;</DIV>     <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20     class=3D763431413-05012001>Hope this helps.</SPAN></FONT></DIV>     <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20     class=3D763431413-05012001></SPAN></FONT>&nbsp;</DIV>

    <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
    class=3D763431413-05012001>Regards,</SPAN></FONT></DIV>
    <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
    class=3D763431413-05012001></SPAN></FONT>&nbsp;</DIV>     <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20     class=3D763431413-05012001>Ranganath</SPAN></FONT></DIV>     <BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">       <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT = face=3DTahoma=20
      size=3D2>-----Original Message-----<BR><B>From:</B> <A=20
      href=3D"mailto:root_at_fatcity.com">root_at_fatcity.com</A>=20
      [mailto:root_at_fatcity.com]<B>On Behalf Of </B>bunyamin=20
      karadeniz<BR><B>Sent:</B> Wednesday, January 03, 2001 5:36=20
      PM<BR><B>To:</B> Multiple recipients of list =
ORACLE-L<BR><B>Subject:</B>=20
      urgent.....error in droping a user . <BR><BR></DIV></FONT>
      <DIV><FONT face=3DArial size=3D2>When I want to drop a user with =
some objects=20
      I can not do it. Here below is the error.</FONT></DIV>
      <DIV><FONT face=3DArial size=3D2>Can you help =
me=3D????????????**</FONT></DIV>
      <DIV>&nbsp;</DIV>
      <DIV><FONT face=3DArial size=3D2>SQL&gt; drop user mehmet =
cascade;<BR>drop=20
      user mehmet cascade<BR>*<BR>HATA sat=FDr 1:<BR>ORA-00604: =
tekrarlayan SQL 1=20
      d=FCzeyinde hata olu=BFtu <BR>ORA-00942: tablo yada g=F6r=FCnt=FC =
mevcut degil=20
      (table or view does not exist)</FONT></DIV>
      <DIV>&nbsp;</DIV>
      <DIV>&nbsp;</DIV>
      <DIV>&nbsp;</DIV>
      <DIV>&nbsp;</DIV>
      <DIV>&nbsp;</DIV>
      <DIV>&nbsp;</DIV>
      <DIV>&nbsp;</DIV>
      <DIV><FONT face=3DArial=20
      =
size=3D2>**********************************************<BR>Bunyamin K.=20
      Karadeniz<BR>Information Technologies Dept.<BR>Database Group Tel=20
      :90-312-2873565/1681<BR>HAVELSAN Ankara /=20
Received on Fri Jan 05 2001 - 08:59:10 CST

Original text of this message

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