Article View: comp.databases.oracle.server
Article #52Re: orcle trobule shooting
From: DA Morgan
Date: Sun, 24 Oct 2004 17:27
Date: Sun, 24 Oct 2004 17:27
34 lines
2459 bytes
2459 bytes
ashok wrote: > Dear all! > Your irritation is justifiable.Actually the problem is related to data > recovery. > I am sorry for not making it clear. > The problem is > My hardisk got completely dead and somehow I could recover the > datafiles but index datafiles and related control files could not be > recovered. > So now my question is can it possible to create new index files from > the now available datafiles.? > It could save lot of time and work for me otherwise I have to manually > create them. > > > regds, > arj Of course. The question is can you start the database and query the tables? If yes then what stops you from creating the indexes and control files? But based on everything else in this thread ... I would advise you to find someone that knows what they are doing to help you and give you some training. And please stop cross-posting this to every usenet group you can spell. The only group where this is relevant is c.d.o.server. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)
Technical Details
Message-ID:
<1098638823.665203@yasure>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!newsfeed.stanford.edu!sn-xit-03!sn-xit-08!sn-post-01!supernews.com!corp.supernews.com!not-for-mailReferences:
<1dc813f.0410230523.24aa571b@posting.google.com> <%rEed.9787$lp6.7300@okepread01> <1dc813f.0410232227.30775a6b@posting.google.com>Show Full Headers
Complete Article Headers
X-Google-Thread: fa4f9,1f83a6dafd96062b X-Google-Thread: f5464,1f83a6dafd96062b X-Google-Thread: f99a8,1f83a6dafd96062b X-Google-Thread: 103117,1f83a6dafd96062b X-Google-Attributes: gidfa4f9,gidf5464,gidf99a8,gid103117,public X-Google-Language: ENGLISH,ASCII-7-bit Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!newsfeed.stanford.edu!sn-xit-03!sn-xit-08!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan <damorgan@x.washington.edu> Newsgroups: comp.databases.oracle.server,comp.databases.oracle.tools,comp.databases.oracle.misc,cern.oracle.cde Subject: Re: orcle trobule shooting Date: Sun, 24 Oct 2004 10:27:55 -0700 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1098638823.665203@yasure> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <1dc813f.0410230523.24aa571b@posting.google.com> <%rEed.9787$lp6.7300@okepread01> <1dc813f.0410232227.30775a6b@posting.google.com> In-Reply-To: <1dc813f.0410232227.30775a6b@posting.google.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@oracle.advtechserv.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 34