Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,152,936 members, 7,817,739 topics. Date: Saturday, 04 May 2024 at 06:19 PM

I Use Quite Old App - Dbase PLUS 11 - Programming - Nairaland

Nairaland Forum / Science/Technology / Programming / I Use Quite Old App - Dbase PLUS 11 (938 Views)

Can I Use Hp Pavilion G6 For Programming??? / What Programming Language Can I Use To Achieve This? / Quite Old Database App From My Boss (2) (3) (4)

(1) (Reply)

I Use Quite Old App - Dbase PLUS 11 by adelinacarrillo(f): 10:56am On Jul 04, 2018
For many years I've been creating many databases in it. Only a day ago one of it stopped opening, I checked up other database, it were valid. I decided to fix dbase by the facilities, some programs from Google and I finally I got - First.dbf is not a table. I still can't understand what I done.
Re: I Use Quite Old App - Dbase PLUS 11 by Serlangley(m): 4:00pm On Jul 06, 2018
I assume you have no backup and you are running in NOARCHIVELOG mode, otherwise you wouldn't be asking this question.
Assuming that your db file is really corrupted, then you can startup the database without this file:
Also you may apply following articles, guides and etc…
https://support.microsoft.com/en-us/help/193952/how-to-troubleshoot-to-resolve-suspected-corruption-in-visual-foxpro
https://download.cnet.com/Recuva/3000-2242_4-10753287.html
https://www.fixtoolbox.com/dbffix.html
1. Take a full backup of all your current db files, control files, redo log files.
2. Startup mount the instance
3. ALTER DATABASE DATAFILE 'fullpath/filename' OFFLINE DROP;
4. ALTER DATABASE OPEN;
This will drop the file from your db, so all data in it will be lost, but the data in other tablespaces will be accessible.
If this doesn't work, restore to its original state using the backup taken in step 1.
However, before concluding that your file is corrupt, try to see what happened to it.
Post the following info:
Your archivelog/noarchivelog mode.
Tablespace to which this file belongs.
Oracle error when starting up the database.
Also, startup mount your db and :
SELECT * FROM V$DATABASE;
SELECT * FROM V$DBFILE;
SELECT * FROM V$RECOVER_FILE;

(1) (Reply)

MIT Inventor App / Online Remote Job Opening (web Developer) / I Need Help On My Fina L Year Project Plsssssssssssssssss

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 12
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.