Change Account Status

How to change the account status of an EXPIRED account (without knowing the account's password)Requirement: SYSTEM or SYS access1. Identify the value of the passwordselect name,password from SYS.USER$ where name=‘USERNAME’;2. Change the account status by using same password:alter user USERNAME identified by values '< password retrieved above >';

Strange error when renaming a table

ORA-14047: ALTER TABLE INDEX RENAME may not be combined with other operationsWhen we try to rename a table or index name in Oracle, we use a simple command as followingALTER TABLE [SCHEMA_NAME].[OLD_TABLE_NAME] RENAME TO [NEW_TABLE_NAME];If we put into schema names to this command, we can deal with ORA-14047 error.This error raise when we put schema ...

The Best Terminal Emulator for Mac OS X

Mac OS X includes a great terminal editor, but among the handful of alternatives is one that easily rises above them all. iTerm2 is our pick for the best terminal emulator for Mac OS X thanks to its vast number of time-saving features and high level of customizability. Source: The Best Terminal Emulator for Mac ...

Browse Categories

%d bloggers like this: