Results 1 to 13 of 13
  1. #1
    Join Date
    Feb 2004
    Posts
    9

    Unanswered: Recover Deleted Tablespace

    Hi all,

    I accidentally deleted my PROD table space. Is there anyway for me to get it back without a backup?

    Thanx

  2. #2
    Join Date
    Jan 2002
    Posts
    1
    You can't recover a permenant Tablespace without a backup.

  3. #3
    Join Date
    Feb 2004
    Posts
    9
    can I do a rollback or anything. I really need help.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    > Is there anyway for me to get it back without a backup?
    NO!
    Why if you did not care enough about the data to back it up, why do you care now about it?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >can I do a rollback or anything.
    Rollback what?
    You said the file got deleted.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    Feb 2004
    Posts
    9
    >Rollback what?
    >You said the file got deleted.

    It did...is there anyway to use the UNDO tablespace and use that?

  7. #7
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >>You said the file got deleted.
    >It did.
    This is an OS "issue" not an Oracle issue.
    This is a prime example why backups should have higher priority than eating, drinking or even breathing.
    So why don't you have ANY backups?
    Why is the data so imprtant now when it wasn't backed up this last weekend?
    What do you plan on doing now? Updating your resume'?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  8. #8
    Join Date
    Feb 2004
    Posts
    9
    >What do you plan on doing now? Updating your resume'?

    Yes...thanx for the flame...

  9. #9
    Join Date
    Jul 2003
    Posts
    2,296
    I hope at least you export your prod tablespace and it's contents on a regular basis?

    Logical backups can come in handy. Especially since you were not doing physical backups.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  10. #10
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    If you are running Oracle9 you can use Flashback.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  11. #11
    Join Date
    Jul 2003
    Posts
    2,296
    Quote Originally Posted by cis_groupie
    If you are running Oracle9 you can use Flashback.
    sorry, but this will not help.
    Flashback is for recovering DML.

    This person DELETED a datafile from the hard disk.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  12. #12
    Join Date
    Feb 2004
    Posts
    9
    can I re-create the schema and tablespace and use flashback to repopulate the missing data?

  13. #13
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    The_Duck, I stand corrected - I misread the post.

    (I must not post an answer until I've read the complete problem
    I must not post an answer until I've read the complete problem
    etc etc etc another 98 times)
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

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