Reputation
2,619
Top tag
Next privilege 3,000 Rep.
Cast close & reopen votes
Badges
6 20
Newest
 Necromancer
Impact
~261k people reached

May
17
reviewed Approve SQLite3 - remove duplicates by multiple columns
May
15
comment How to restore and recover a datafile when it has no backup and is lost?
why does it not work on ASM?
May
11
comment How to find the latest SQL statements within the database?
'inst_id' stands for the instance Id, itdoes not meaninstallation id.
May
7
awarded  Necromancer
Apr
13
comment Oracle: guaranteeing unmodified database state with queries?
I think the proper way to do this is using the utilities Oracle supplies for this purpose , e.g. privileges, views.
Apr
9
revised Query to get ORACLE_HOME path in Oracle 11G
added 131 characters in body
Apr
9
comment Query to get ORACLE_HOME path in Oracle 11G
Why do you need this?
Apr
9
answered Query to get ORACLE_HOME path in Oracle 11G
Apr
7
revised Oracle schema import is not importing all the tables present in the schema dump file
edited tags
Apr
7
comment search misses indexed column
@jynus: reverse index has a special meaning for some dbms systems (e.g. Oracle). Maybe it is better to avoid this name for the second index.
Apr
2
comment Oracle: Traversing a graph of my foreign keys?
off topic @ypercube: you should check your surreal number link on your profile page dba.stackexchange.com/users/993/ypercube
Mar
10
answered Should new roles be assigned to SYS
Feb
25
comment Is there any other way that we can take auto backup in oracle 11g apart from RMAN?
@ora-600: setting datafiles in backup mode is a reliable method for doing backups. It was the method that was used before RMAN was released and it is used today by tools that uses snapshots of file systems for the backup like Netapps SnapManager for Oracle.
Feb
23
comment Fast restore of dropped partitions
I had the following stament in the import: remap_table=ORIGINAL_USER.ORIGINAL_TABLE:RESTORE_USER.RESTORE_TABLE and so the table created was acturally a table with name "RESTORE_USER.RESTORE_TABLE". I changed this.
Feb
23
revised Fast restore of dropped partitions
changed name of remapped table
Feb
18
revised Fast restore of dropped partitions
typos
Feb
16
revised Fast restore of dropped partitions
edited tags
Feb
16
asked Fast restore of dropped partitions
Jan
19
reviewed Edit How to migrate data of to another sql server
Jan
19
revised How to migrate data of to another sql server
formatting