Reputation
2,146
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
2 9 23
Newest
 Yearling
Impact
~168k people reached

Mar
17
comment User Password Expiry date is null in user_users?
See also Using Data Dictionary Views to Find Information About Users and Profiles.
Jan
4
awarded  Yearling
Dec
17
revised Prevent auto commit of DROP without SET AUTOCOMMIT OFF
improve post structure, add new 12c table recovery feature description
Nov
8
awarded  Custodian
Nov
5
reviewed Reviewed MySQL improve query syntax
Nov
5
revised MySQL improve query syntax
Improve formatting, fix title, minor tweaks
Nov
5
awarded  Custodian
Nov
5
reviewed Edit Linked Server Security under SQL Agent Job Context
Nov
5
revised Linked Server Security under SQL Agent Job Context
edit tags, improve formatting, minor tweaks
Nov
5
reviewed No Action Needed Pros and cons in combining current data and historical data in the same table
Nov
5
reviewed No Action Needed Error Grouping By Multiple Columns using CASE
Nov
5
reviewed No Action Needed MySQL data to Postgres every X time
Nov
5
reviewed No Action Needed Domain group as single login, but still many different database users?
Nov
2
answered How to install oracle 11g XE and use the data files of another instance (like Postgres)?
Oct
31
awarded  Disciplined
Oct
31
comment ORACLE restore - how to restore specific .bkp file?
Also notice that in my example we made sure that the control file is sufficiently old, otherwise Oracle would attempt to recover the data files up to and including the latest change in database which is probably not what you want. So first, restore the sufficiently old control file (possibly from the controlfile autobackup), then place your database, archive log and differential backup files to Recovery Area on disk and say CATALOG RECOVERY AREA, so that backups are added to RMAN repository (control file), and, finally, RESTORE DATABASE, RECOVER DATABASE, ALTER DATABASE OPEN RESETLOGS.
Oct
31
comment ORACLE restore - how to restore specific .bkp file?
Probably your database is in ARCHIVELOG mode and the backups you're restoring from was taken online (hot backup), and there are archive logs which need to be applied to the data files you restored to make them consistent with your current control file. This is called the roll forward phase. Or you have differential database backups which should also be applied to the restored data files. In either case, you need to say RECOVER DATABASE just after RESTORE DATABASE, to apply all the changes made to the database since the last backup, only then you can open with RESETLOGS.
Oct
4
awarded  Famous Question
Sep
6
comment oracle tablespaces
Did you try to set quota to 0 on USER tablespace before importing data? For example, alter user YOURUSERNAME quota 0 on tablespace users. If the user doesn't have the necessary quota on the tablespace where the data should be imported from the dump file, then the data is imported in default tablespace set for the user, e. g. alter user YOURUSERNAME default tablespace newtbs. Check this out docs.oracle.com/cd/E11882_01/server.112/e22490/…
Sep
3
comment Mysql performance tunning
Better be asked on dba.se