Search...
FAQs Subscribe
Pie
FAQs
Recent topics Flagged topics Hot topics Best topics
Search...
Search within Oracle/OAS Search Coderanch
Advance search Google search
Register / Login
advertise on coderanch granny book review grid thread boost polymorphism
Win a copy of Resilient Oracle PL/SQL: Building Resilient Database Solutions for Continuous Operation this week in the JDBC and Relational Databases forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
building better world book meaningless drivel book review grid thread boost advertise on coderanch
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Junilu Lacar
  • Tim Cooke
Saloon Keepers:
  • Carey Brown
  • Stephan van Hulst
  • Tim Holloway
  • Peter Rooke
  • Himai Minh
Bartenders:
  • Piet Souris
  • Mikalai Zaikin

Drop Table issue

 
Murad Iqbal
Ranch Hand
Posts: 90
posted 18 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
I need to drop few tables from my database. I am running Oracle 10G. The tables are dropped successfully, however a new table with a name 'BIN$G0Tao9jLTq+n94JPT7fNSA==$0' appears which apparently looks like garbage. This table cannot be dropped. It has the same structure as the deleted table. How to stop oracle to keep table backup like this?
 
Jeanne Boyarsky
author & internet detective
Posts: 41605
883
I like...
Eclipse IDE VI Editor Java
posted 18 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Murad,
Oracle is keeping it so you can rollback to a different state. If you really wanted to, you could disable this, but I wouldn't recommend it. This is a good backup and recovery feature.

[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2

 
Murad Iqbal
Ranch Hand
Posts: 90
posted 18 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
i dont need the backup. how can i disable it?
 
Jeanne Boyarsky
author & internet detective
Posts: 41605
883
I like...
Eclipse IDE VI Editor Java
posted 18 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
This article has some good information. Also, use a search engine to search for "RMAN" or "recovery manager".

[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2

 
Thank you my well lotioned goddess! Here, have my favorite tiny ad!
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
reply
reply
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!
Similar Threads
More...