+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 12
  1. 05-13-2005 07:56 PM #1
    kris123's Avatar
    kris123
    kris123 is offline Banned
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639

    recycle bin$,,, in 10g

    Hi Hun,

    How do u empty this recycle bin in 10g?

    Thanks
    Reply With Quote Reply With Quote
  2. 05-13-2005 08:06 PM #2
    Axr2
    Axr2 is offline Senior Advisor
    Join Date
    Oct 2002
    Posts
    807
    Shutdown database.
    Mount in restricted mode.
    Issue "drop database;".

    That will do it.
    Reply With Quote Reply With Quote
  3. 05-13-2005 08:14 PM #3
    kris123's Avatar
    kris123
    kris123 is offline Banned
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Originally posted by Axr2
    Shutdown database.
    Mount in restricted mode.
    Issue "drop database;".

    That will do it.
    Why are u so cruel hun?
    Reply With Quote Reply With Quote
  4. 05-13-2005 08:51 PM #4
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by kris123
    Why are u so cruel hun?
    Because you are so lazy. You won't even take 5 minutes to look on OTN.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."
    Reply With Quote Reply With Quote
  5. 05-13-2005 10:51 PM #5
    kris123's Avatar
    kris123
    kris123 is offline Banned
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    sighhhhh :(
    Reply With Quote Reply With Quote
  6. 05-13-2005 11:49 PM #6
    simply_dba's Avatar
    simply_dba
    simply_dba is offline Senior Member
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    Kris honey !!
    Don't sigh !! You got to read some documents.We seek help here only when we are struck with a problem and there is no solution in immediate vicinity and we are unsure of the solution.
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA
    Reply With Quote Reply With Quote
  7. 05-14-2005 02:32 PM #7
    kris123's Avatar
    kris123
    kris123 is offline Banned
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    ohh im sorry honey...
    Im scheduled to read it from the beginning, its very hard
    to get a momentum though coz im so busy right now.
    Anyway I'll read it sooner.

    Last edited by kris123; 05-14-2005 at 02:35 PM.
    Reply With Quote Reply With Quote
  8. 05-14-2005 02:57 PM #8
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Originally posted by Axr2
    Shutdown database.
    Mount in restricted mode.
    Issue "drop database;".

    That will do it.
    100% correct!
    Reply With Quote Reply With Quote
  9. 05-14-2005 09:13 PM #9
    kris123's Avatar
    kris123
    kris123 is offline Banned
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Papa! , If u have nothing to do, don't do it here
    This forum is for serious converstation only, ok
    Reply With Quote Reply With Quote
  10. 05-14-2005 09:17 PM #10
    kris123's Avatar
    kris123
    kris123 is offline Banned
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Im curious thugh, if u drop a database, is there an option
    to includes its associated data files in the OS?
    All files like redo,data,control,dumps,etc.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules

 Click Here to Expand Forum to Full Width