1,893 reputation
1820
bio website arsanukaev.blogspot.com
location Grozny, Chechen Republic, Russia
age 28
visits member for 3 years, 7 months
seen 16 mins ago

A programmer (loves Haskell, Erlang, Scheme)

A DBA (mostly Oracle)

Oracle Database Administrator Certified Associate

Passed Oracle Database OCP exam recently

One of my best answers: "Practical use of curried functions?"

On Twitter.


3h
reviewed No Action Needed How can I use parameters of type Int32 from an environment for an integration services package in a SQL Server 2008 job?
3h
comment Delete all the data from all tables
The question obviously has "oracle" tag.
5h
comment Delete all the data from all tables
Or better TRUNCATE instead of DELETE FROM – there's really no need to generate extra redo vectors in the redo log if all you want to do is just get rid of the data.
6h
reviewed Reviewed Changes the default database owner in SQL Server 2008
10h
reviewed No Action Needed How to create a Postgres trigger to ensure field is non-updateable
10h
reviewed No Action Needed Denormalization Strategies: When is it appropriate to create redundancy for faster querying?
11h
answered oracle tablespaces
1d
reviewed No Action Needed MySQL: What are the pros and cons of running with engine=Memory vs on a memory-mapped filesystem?
1d
reviewed No Action Needed Convert yymmdd to datetime using ssis derived column
1d
reviewed No Action Needed How to append value of column with double quotes (add quotes around string)
1d
reviewed No Action Needed Oracle error 12154 while importing DMP file
1d
reviewed No Action Needed How to move 200 materialized views without having to re-create in the new home
2d
reviewed No Action Needed How do I ORDER BY typical software release versions like X.Y.Z?
2d
revised High Traffic Errors - Unknown Cause
edit tags, remove confusing part about 'SQL server'
2d
reviewed Reviewed High Traffic Errors - Unknown Cause
2d
suggested suggested edit on High Traffic Errors - Unknown Cause
Aug
17
reviewed No Action Needed Building a branched versioning model for relational databases
Aug
17
reviewed Reviewed How do i compare current table and history table so that i get to know which data is upated or deleted from current table
Aug
17
comment How do i compare current table and history table so that i get to know which data is upated or deleted from current table
What have you tried? You should put some details in your question. Do you have any working code? Here's the article on how to ask questions on DBA.SE.
Aug
17
comment ORA-01033 “ORACLE initialization or shutdown in progress” caused by ORA-10567 “REDO is inconsistent with data block”
The STATUS column of the v$instance view will tell you your database state. ORA-0600 sounds like a nasty problem and often calls for support. I would try to read alert log and perform complete recovery first, then ask for Oracle support.