Oracle Logo

Oracle Popular Questions, Answers, Tips & Manuals

Do you work here? Claim your company

  • 24 Products
  • 67 Answers
  • 7K Views
0helpful
2answers

How can I restore my SQL database from .frm files?

You just copy the .frm files to the to the databse folder but you also need to copy the ib_logfiles and ibdata file into your data folder. I have just copy the .frm files and copy those files and just restart the server and my database is restored. @ Best Professional Resume Writing Service Online from Washington USA...
10/22/2015 1:24:07 PM • Oracle MySQL... • 312 views • 0 helpful votes
0helpful
2answers

Recovering blog from mysql sql file after failed upgrade?

from command line you can use: mysqlcheck -A --auto-repair or read this about soft http://www.computing.net/answers/dbase/recover-database-after-a-system-crash/1558.html
10/23/2015 5:49:58 PM • Oracle MySQL... • 192 views • 0 helpful votes
1helpful
2answers

'Table does not exist' error in MySQL, although it really exists

it usually means that no table exists in the default database with the given name. In some cases, it may be that the table does exist but that you are referring to it incorrectly. Maybe your database and table names are case sensitive if they are located on a file system that has case-sensitive file names. Or perhapsall references to a given table within a query must use the same lettercase. Use SHOW TABLES to check which tables are in the default database. Well, if you are sure that table is exist and you write its name exactly such it should be, then I suppose something wrong with the database, it can be seriously corrupt. And in this case you need a professional help. This tool must help at any rate - Recovery Toolbox for MySQL https://mysql.recoverytoolbox.com/
3/11/2015 8:45:37 AM • Oracle MySQL... • 189 views • 1 helpful votes
1helpful
1answer

DBF file lost after OS reinstalled

Some helpful resources for you: Non-commercial project, which can give you an alternative view to your issue:- http://www.filerepairforum.com/forum/databases/databases-aa/dbase-iv-clipper-foxpro/429-how-can-i-open-corrupted-dbf-file-via-ms-foxpro One more method, must be DBF Fix Toolbox - this is shareware software You may download its demo: http://www.dbf.fixtoolbox.com/ - who knows, apparently it also can resolve the trouble. Another fresh alternative way The new database is useless. Drop it and its associated service. Copy your files, all the database files (control file, redo logs, data, configuration files...) in the new hardisk, if possible at the same location (directories). Then use oradim to create the service: oradim -new <sid> -startmode manual Start the service if it is not already started. Execute sqlplus "/ as sysdba" and try a startup. If all files were copied in the same location, this should work.
11/1/2014 12:21:19 PM • Oracle Computers... • 162 views • 1 helpful votes
0helpful
1answer

Software comparisions

Helen, I suggest if you want to compare management software, a good start would be to go to a specialist magazine site where they do reviews. I use PC Pro quite often. Depends how specialist you need.
2/5/2014 10:12:21 AM • Oracle Computers... • 65 views • 0 helpful votes
0helpful
1answer

I forget my security code Nokia 1100 RH-18 Code

you will have to contact the phone provider with your details and supply proof of your ID eg:passport or motor car licence or registration no

otherwise you might have to pay to get it removed

or you could

http://unlock.nokiafree.org/

select your phone

select your network

select your imei

hope it helps you

4/29/2012 3:07:27 PM • Oracle Facebook... • 170 views • 0 helpful votes
0helpful
1answer

What mean sie of pogo is disabled

try installing Adobe Flash Player and see if that don't render the situation
5/10/2012 3:09:30 AM • Oracle Computers... • 44 views • 0 helpful votes
0helpful
2answers

What is .sdf file

The .sdf or standard data file is used for storing data in a structured format; uses fields of fixed lengths to store values; can be imported and exported by various database and data analysis programs; commonly used for transferring data between different programs.
9/3/2011 5:33:28 AM • Oracle 10g... • 365 views • 0 helpful votes
0helpful
1answer

NEED PRODUCT KEY FOR MICROSOFT

ring up the lockal microsoft call center and you may get it from them. just follow the promps
3/16/2011 7:08:51 AM • Oracle 10g... • 56 views • 0 helpful votes
1helpful
1answer

I installed oracle 10g express edition.now I dono

Follow these steps:
  1. Open the Windows Services utility: From the Start menu, select All Programs, then Administrative Tools, and then Services.
  2. If any of the following Oracle services exist and have the status Started, then select each of the services, and click Stop:
    • OracleXE
    • OracleXETNSListener
    • OracleJobSchedulerXE
    • OracleXEClrAgent
    • OracleMTSRecoveryService
  3. Exit Services.
See also the Microsoft online help for more information on stopping services.
7.2.2 Step 2: Remove the Oracle Database XE Registry Editor Settings Follow these steps:
  1. Log on to Windows with Windows administrative privileges.
  2. Ensure that you followed the instructions under "Step 1: Stop the Oracle Database XE Services" to stop the Oracle Database XE services.
  3. Start the Registry Editor at a command prompt:
    SYSTEM_DRIVE:\> regedit
  4. Go to HKEY_CLASSES_ROOT.
  5. Delete the following keys:
    • NEED TO CONFIRM THE XE-SPECIFIC ONES.
  6. Go to HKEY_CURRENT_USER\Software.
  7. Under Microsoft\Windows\CurrentVersion\Explorer\MenuOrder\Start Menu\Programs, delete the Oracle Database 10g Express Edition key.
  8. Go to HKEY_LOCAL_MACHINE\SOFTWARE and search for the ORACLE group key.
  9. Expand the ORACLE group key and then delete the KEY_XE and OracleMTSRecoveryService keys.
  10. Go to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI.
  11. Expand the ODBCINST.INI key and remove the Oracle in XE key.
  12. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services.
  13. Delete the following keys:
    • OracleServiceXE
    • OracleXEClrAgent
    • OracleXETNSListener
  14. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application.
  15. Delete the Oracle.xe key.
  16. Exit the Registry Editor.
  17. Restart your computer.
7.2.3 Step 3: Update the System Variable Path Follow these steps:
  1. Open System from the Control Panel.
  2. In the System Properties dialog box, click the Advanced tab, then click the Environment Variables button.
  3. Select the system variable Path and edit the Path variable to remove the Oracle Database XE entry. For example:
    C:\oraclexe\app\oracle\product\10.2.0\server\bin;
  4. Save your changes and then exit the Control Panel.
7.2.4 Step 4: Remove Oracle Database XE from the Start Menu and Desktop Follow these steps:
  1. Select Start, then All Programs, and then Oracle Database 10g Express Edtion.
  2. Right-click Oracle Database 10g Express Edtion and from the menu, select Delete.
  3. On the desktop, right-click the Get Started with Oracle Database 10g Express Edition icon and from the menu, select Cut.
7.2.5 Step 5: Remove the Oracle Database XE Directories Follow these steps:
  1. Ensure that you have followed the instructions under "Step 1: Stop the Oracle Database XE Services" to stop all Oracle Database XE services.
  2. From the Windows Explorer, navigate to the directory where you installed Oracle Database XE, for example, c:\oraclexe.
  3. Right-click the Oracle Database XE installation directory and from the menu, select Delete.
7.2.6 Step 6: Install and Run the Windows Installer CleanUp Utility Run the Windows Installer CleanUp utility to remove the Windows Installation configuration information for the Oracle Database XE installation. You can download it from Microsoft at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;290301
he deinstallation completes, click Finish.
9/14/2010 4:50:36 AM • Oracle Database... • 638 views • 1 helpful votes
0helpful
1answer

NEED TO CALCULATE AGE IN ORACLE 10G

this will be close:
SELECT ROUND( (SYSDATE - DOB)/365.24,0) FROM MYTABLE;
9/12/2010 5:03:09 PM • Oracle 10g... • 289 views • 0 helpful votes
0helpful
1answer

How to convert sdf file in xls file ?

SDF file is a compact relational database also called a SQL server database. Designed for the application that runs on mobile devices and desktop. If you only want to access SDF files in Excel sheets then you can see your SDF files in SQL Server or Visual Studio.
7/26/2010 8:34:02 AM • Oracle 10g... • 1,082 views • 0 helpful votes
11helpful
1answer

I want to disable the listener log in Oracle DBA.

Hi,
You can disable the “logging listener” feature in the listener by entering the following commands in the "listener.ora" file:
LOGGING_LISTENER = OFF

To turn off listener logging dynamically is also possible by launching LSNRCTL and typing:

SET LOG_STATUS OFF
This works if the listener is running.
I hope it helps.
If you would like to vote for the answer, this will help the others to see the similar problems solved and also will be a satisfaction factor for me to continue helping you.
All the best.
3/27/2010 11:21:50 PM • Oracle Database... • 2,541 views • 11 helpful votes
0helpful
1answer

Name of simple computer only surfs and emails

A netbook is relatively inexpensive ($200-$300) and is designed primarily to surf the web and send email. It allows other functions, but you don't have to use them.

Google's Chrome OS will be designed to do exactly what you're describing, but is not available yet. You can read more about it at: http://en.wikipedia.org/wiki/Google_Chrome_OS
7/16/2010 9:13:19 PM • Oracle Database... • 72 views • 0 helpful votes
0helpful
1answer

Hi, New to Oracle, what resource would you reco...

http://psoug.org/
PSOUG.org is an Oracle community resource dedicated to supporting users and developers of the Oracle database. lots of great code samples.

http://www.iselfschooling.com/

offers free training. It's a great site for new users / dbas
5/20/2010 1:02:42 PM • Oracle Database... • 202 views • 0 helpful votes
0helpful
1answer

Hi. when i start the youcam 3 i only get alot of colors

Reinstall YOUCAM. Let me know how it goes.
3/18/2010 10:10:14 PM • Oracle Change... • 83 views • 0 helpful votes
2helpful
4answers

Whst is the difference between .mdf,.ldf &

LDF - layered data file, is the transaction log file for your database. It allows you to roll back changes you made to the data to a particular point and is used in rebuilding the data should it become corrupted.

MDF - Meta data file, is your actual data

SDF - Is a sequential data file, a flat file that can be used for compatibility with MS-SQL server, MySQL, etc.

12/3/2009 12:16:51 PM • Oracle 10g... • 1,061 views • 2 helpful votes
1helpful
3answers

I want to no what my name means?

What does Asiana Brefford mean?
10/9/2009 6:22:13 PM • Oracle Database... • 1,492 views • 1 helpful votes
1helpful
1answer

How to run tally4.5 in winxp

if you have cd, then install manually otherwise proceed online install which ever is easier for you! have fine!
12/17/2009 9:16:19 AM • Oracle 10g... • 202 views • 1 helpful votes
Not finding what you are looking for?

Ask a Question

Usually answered in minutes!

Top Oracle Experts

Bonded Repair

Level 3 Expert

407 Answers

ADMIN Eric
ADMIN Eric

Level 3 Expert

39381 Answers

Sameera Banu
Sameera Banu

Level 2 Expert

85 Answers

Are you an Oracle Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...