DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Recreating oracle database

  1. 10-03-2003, 12:20 PM #1
    sfdba
    sfdba is offline Junior Member
    Join Date
    Jan 2002
    Posts
    40

    Unhappy Recreating oracle database

    My Oracle database is not starting due to missing index tablespace file and I don't have the internal password to restore the database....
    ...since I'am having the latest export file can anyone pls help me how to proceed with re-creating the oracle database and then importing the export file....

    Will be very greatefull who can help me out!!!
    Thanx & Regards,
    sfdba
    Reply With Quote Reply With Quote
  2. 10-03-2003, 12:34 PM #2
    stecal's Avatar
    stecal
    stecal is offline Senior Advisor
    Join Date
    May 2002
    Posts
    2,645
    You were told in a different thread what to do, and even how to do it. If you can't do that (read and follow instructions, look up a simple command - even when given a link to the documentation about it), there is no help for you. Why don't you tell us which personal reference book(s) you own and what it is you don't understand about what you were told previously?
    Reply With Quote Reply With Quote
  3. 10-03-2003, 12:43 PM #3
    sfdba
    sfdba is offline Junior Member
    Join Date
    Jan 2002
    Posts
    40
    Yeah Stecal there is a link given to the document but as I mentioned in my last thread I don't have a metalink userid and password...anyways Thanx
    Reply With Quote Reply With Quote
  4. 10-03-2003, 01:08 PM #4
    stecal's Avatar
    stecal
    stecal is offline Senior Advisor
    Join Date
    May 2002
    Posts
    2,645
    My bad about your not having access to MetaLink, but you do have access to Oracle documentation.

    http://download-west.oracle.com/docs...1/dba.htm#1227
    Reply With Quote Reply With Quote
  5. 10-05-2003, 03:26 PM #5
    stecal's Avatar
    stecal
    stecal is offline Senior Advisor
    Join Date
    May 2002
    Posts
    2,645
    If you could log on, you could try dropping the tablespace including contents, assuming this was just an index tablespace. Then recreate it.
    Reply With Quote Reply With Quote
  6. 10-06-2003, 01:34 AM #6
    akhadar
    akhadar is offline Advisor
    Join Date
    May 2001
    Posts
    736
    At the starting of this forum there is one thread at the top most read it carefully.Still u doesnot understand take a brake from your work pack all your fundamental books read them.
    Reply With Quote Reply With Quote
  7. 10-06-2003, 10:28 AM #7
    julian
    julian is offline Senior Advisor
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: Recreating oracle database

    Originally posted by sfdba
    My Oracle database is not starting due to missing index tablespace file and I don't have the internal password to restore the database....
    ...since I'am having the latest export file can anyone pls help me how to proceed with re-creating the oracle database and then importing the export file....

    Will be very greatefull who can help me out!!!
    Thanx & Regards,
    sfdba
    Now if it's just an INDEX TABLESPACE, what's the big deal? Isn't it easier to recreate the indexes than to recreate the database?

    About the "internal" password: why don't you just recreate the password file with another password :-)
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width