Oracle Computers & Internet - Popular Questions, Answers, Tips & Manuals
'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/
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.
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
I installed oracle 10g express edition.now I dono
Follow these steps:
-
Open the Windows Services utility: From the Start menu, select All Programs, then Administrative Tools, and then Services.
-
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
-
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:
-
Log on to Windows with Windows administrative privileges.
-
Ensure that you followed the instructions under "Step 1: Stop the Oracle Database XE Services" to stop the Oracle Database XE services.
-
Start the Registry Editor at a command prompt:
SYSTEM_DRIVE:\> regedit
-
Go to HKEY_CLASSES_ROOT.
-
Delete the following keys:
-
NEED TO CONFIRM THE XE-SPECIFIC ONES.
-
Go to HKEY_CURRENT_USER\Software.
-
Under Microsoft\Windows\CurrentVersion\Explorer\MenuOrder\Start Menu\Programs, delete the Oracle Database 10g Express Edition key.
-
Go to HKEY_LOCAL_MACHINE\SOFTWARE and search for the ORACLE group key.
-
Expand the ORACLE group key and then delete the KEY_XE and OracleMTSRecoveryService keys.
-
Go to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI.
-
Expand the ODBCINST.INI key and remove the Oracle in XE key.
-
Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services.
-
Delete the following keys:
-
OracleServiceXE
-
OracleXEClrAgent
-
OracleXETNSListener
-
Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application.
-
Delete the Oracle.xe key.
-
Exit the Registry Editor.
-
Restart your computer.
7.2.3 Step 3: Update the System Variable Path
Follow these steps:
-
Open System from the Control Panel.
-
In the System Properties dialog box, click the Advanced tab, then click the Environment Variables button.
-
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;
-
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:
-
Select Start, then All Programs, and then Oracle Database 10g Express Edtion.
-
Right-click Oracle Database 10g Express Edtion and from the menu, select Delete.
-
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:
-
Ensure that you have followed the instructions under "Step 1: Stop the Oracle Database XE Services" to stop all Oracle Database XE services.
-
From the Windows Explorer, navigate to the directory where you installed Oracle Database XE, for example, c:\oraclexe.
-
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.
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
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.
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
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,062 views • 2 helpful votes
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?