tablespace dropped
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 27

Thread: tablespace dropped

  1. #1
    Join Date
    Nov 2000
    Posts
    440
    Hi, here is the situation.

    1. tablespace is dropped yesterday(it is a data tablespace, not temp or rbs or system).
    2. not in archivelog mode.
    3. no backup exept full export dated 15 august..
    4. the datafile is not deleted on the os.
    5. The tablespace did not have ddl statement.


    Have any idea how to resolve this?



    [Edited by steeve123 on 10-03-2002 at 11:15 AM]

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    Unfortunately you are in a world of poo. I don't think you have any other choice but to use your last full export.

    Sorry.

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Dec 2001
    Posts
    141
    Unfortunatly, I think that you have lost your datafile ...
    But I've heard about an Oracle tool which name is something like DUL to unload data from a datafile and to generate a dump file ...

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Did the same thing in my early days. Oracle Consulting has a tool that can read the datafiles and spits out the data in a CSV format. For my company, the $2500/day was worth it.
    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."

  5. #5
    Join Date
    Dec 2001
    Posts
    141
    3000$ for just five minutes in my case, but that's worth it ...

  6. #6
    Join Date
    Jan 2001
    Posts
    3,131
    I do hope this was a development box, please tell us it is.

    MH
    I remember when this place was cool.

  7. #7
    Join Date
    Nov 2000
    Posts
    440
    Anyone know what is the product that reads a datafile to extract the data and make an .csv file?

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    It's proprietery to Oracle Consulting. They even rm it from your box when they are through.
    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."

  9. #9
    Join Date
    Nov 2000
    Posts
    440
    What is the name of the product?

  10. #10
    Join Date
    Dec 2001
    Posts
    141
    As I said : the name of the product is DUL (like Data Unloader).

Posting Permissions

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


Click Here to Expand Forum to Full Width