REPOST: Re: Lost oracle database but have the datafiles

Hello Howard,

Here is the problem. I completely lost my harddrive but before I did about a day ago I saved the datafiles, no idea of why I did it. And about 1 week ago I did a export of the schema I care about.

What I need to do is jsut get one table out of the datafile and the rest I dont care about.

I might be abot to get the control files but not the arcive or redos.

I can run the import to create the structure but I need to pull the data from the datafiles if this is at all possible.

Thanks,

Kev

On Mon, 31 Dec 2001 06:29:12 +1100, "Howard J. Rogers" <dba_at_hjrdba.com> wrote:

>Kev,
>
>Your post is not entirely clear... Do you have the datafiles as your post
>title suggests, or do you merely have an export file as your post contents
>suggests?
>
>If you have the datafiles themselves, do you have a control file as well?
>And do you have archives? Because if that's all true, then you can perform
>a standard incomplete recovery and get all your data back, except for the
>last little bit that was in the current online redo log.
>
>If all you've got is the export file, then you'll have to create a brand new
>database from scratch, and run import to get the data back as it was at the
>time you took the export. The easiest way to proceed in that eventuality
>would be to manually create all the right tablespaces (and users), and then
>leave import to create all the tables, indexes and so on, and populate them.
>
>Regards
>HJR

• WAS CANCELLED BY =======: Path: news.sol.net!spool1-nwblwi.newsops.execpc.com!newsfeeds.sol.net!news-out.visi.com!hermes.visi.com!newsfeed1.earthlink.net!newsfeed.earthlink.net!uunet!lax.uu.net!news.navix.net!u-n-c-a-n-c-e-l-l-e-r From: Kev <java2e_at_yahoo.com> Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server Subject: cmsg cancel <l1ru2uk66fa4ci1bb2gjl44rve2ajadqbl_at_4ax.com> Control: cancel <l1ru2uk66fa4ci1bb2gjl44rve2ajadqbl_at_4ax.com> Date: Mon, 31 Dec 2001 05:43:56 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.l1ru2uk66fa4ci1bb2gjl44rve2ajadqbl_at_4ax.com> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009788696 26548 166.102.15.34 (31 Dec 2001 08:51:36 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 31 Dec 2001 08:51:36 GMT X-No-Archive: yes Comment: Anarchy! Fuck You! X-Commentary: I love NewsAgent 1.10, Sandblaster Build 74 (19 March 1999) and the Polaris Cancel Engine V. 6.1 X-Unacanc3l: yes

This message was cancelled from within Mozilla...not Received on Sun Dec 30 2001 - 13:37:52 CST