Oracle 10g: How to create a log file if lost?
Oracle 10g: How to create a log file if lost?
Database
Security: how to lock or unlock Oracle database user accounts
Security: how to lock or unlock Oracle database user accounts
Security: How to switch to another user
Need to become a different Oracle database user? There is a way to login into a another user's account without knowing their password:
Security: How to force user choose a new password
Run this from sqlplus to force Oracle user choose a new password when he/she logs in next time:
Resize or add datafiles using brspace
This is a quick reference for SAP brspace utility.
Oracle 10g: How to drop Oracle database
Dropping database from sqlplus
ORA-16032 error
Archive log in Oracle give me the ORA-16032 error?
Oracle 10g: Two databases with the same name on one server
You can run 2 Oracle instances with the same database name. To do that set the following parameter(s):
Oracle 10g: Oracle automatic memory management
In Oracle10g memory can be managed automatically by setting parameter sga_target.
Oracle - Rename DataFile
Sometimes, we need to rename Datafiles in Oracle, here we show you the alter database method.
How to delete a column
To delete a column from a MySQL table run the following command:
Most Read
All
Month
Week
