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

An Atheist and a programmer (loves Haskell, Erlang, Scheme)

Oracle Database Administrator Certified Associate

Passed Oracle Database OCP exam recently.

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

Commit to Russian Language and Usage!


2h
comment sqlplus: ORA-01017 logon denied from one host but OK from another
Did you try to see what happens at your network interface on the DB server, what the connect descriptor looks like in the end whenever you try to connect from the client machine? I usually employ tcpdump or Wireshark for the debugging purposes.
Jul
25
answered Whether Logfile Shrinking is good or bad one for Performance in SQL?
Jun
1
awarded  Notable Question
Jan
4
awarded  Yearling
Jul
18
awarded  oracle
Jul
17
comment Bulk database update/insert from CSV file
When you load data into the database using SQL*Loader the DBWR process or SQL*Loader process write buffers to data files. When you subsequently move loaded data to other tables the database performs another I/O. I don't think this extra work can be justified. By the way when External Tables utilizes ORACLE_LOADER driver the syntax for defining the input data format is the same used by sqlldr utility because essentially they are the same technology and thus can be used interchangeably. External Tables in this scenario is preferred since there's no need to first load data into the database
Jul
17
answered Bulk database update/insert from CSV file
Jul
16
comment Problem compiling view when it is referencing a table in an other view: insufficient privileges
Ensure that the newly created view is owned by the user which has appropriate privileges on the underlying views and tables.
Jul
16
comment Mounting a database from database files copied from a previous installation
Probably your database is using pfile. If so, locate the file init.ora and edit it with your favourite text editor to update control_files parameter value in it, then startup mount the database.
Jul
15
comment Mounting a database from database files copied from a previous installation
If your database was shut down orderly, and online redo log files are corrupted, you can drop online redo log groups and members while the database is in mounted state, and recreate them in the new destination. For more info, read "Managing the Redo Log" in Database Administrator's Guide.
Jul
15
answered Mounting a database from database files copied from a previous installation
Jul
13
answered Altering the location of Oracle-Suggested Backup
Jul
9
answered Oracle OEM Database Backup Failure
Jul
2
revised Merge two packages into one package in Oracle 10g
edited tags
Jul
2
suggested suggested edit on Merge two packages into one package in Oracle 10g
Jun
26
reviewed No Action Needed MySQL Insert into table, where name = id, if not exist, then insert name and use that ID
Jun
26
revised limit the number of rows returned when a condition is met?
edited tags
Jun
26
revised Convert units of measurement
edited tags
Jun
25
revised pg_upgrade fails with lc_ctype cluster values do not match
improved readability
Jun
25
revised Can I grant privileges to a role without specifying an object?
edited tags