Reputation
2,250
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
14 35
Impact
~190k people reached

Mar
31
awarded  Notable Question
Mar
30
reviewed Approve How can I get SQL Server restore start and end time information?
Mar
26
comment how to prevent any update to my database before a exp operation?
well you could do that for every user except SYS, SYSDBA but then existing sessions would still continue to run and someone could still log on who was in the ORA_DBA group (windows OS) and connect as sys, and jobs would still run..
Mar
25
answered how to prevent any update to my database before a exp operation?
Mar
25
reviewed Approve mysql need help optimizing query
Mar
23
answered Oracle copy DB from one windows server to another
Mar
20
comment migration of oracle xe 10 to xe 11 fails with wrong paths used in the import
I don't suppose just exporting or datapumping the schemas you are interested in rather than a full export will work?
Mar
20
answered What is the query to get the process limit on Oracle 11g?
Mar
19
awarded  Custodian
Mar
19
reviewed Approve Cannot open database “RidaDatabase” requested by the login. The login failed. Login failed for user 'PLESK01\IWAM_plesk(default)'
Mar
18
comment EAV table question
It all depends.... how many entries, your budget for hardware and software or is this a thought experiment? Either way the amount of space a single table occupies versus several tables is not a determining factor in the speed of a query.
Mar
18
comment Failed to connect to oracle SQL Plus
@roukaya from your answer you know how to shutdown and restart the database. Did this solve your problem?
Mar
18
answered Failed to connect to oracle SQL Plus
Mar
16
revised Oracle Text: query scoring with CTXCAT index?
added 215 characters in body
Mar
16
answered Single select from template record oracle
Mar
16
answered Oracle Text: query scoring with CTXCAT index?
Mar
14
comment Removing editioning from an Oracle user
@Phil Post your test case and I will accept it as the answer
Mar
14
answered Removing editioning from an Oracle user
Mar
13
awarded  Notable Question
Mar
12
answered Continuous replication between Oracle Database and Microsoft Azure SQL