360 reputation
1518
bio website
location
age
visits member for 3 years, 7 months
seen Jul 10 at 9:28

May
6
comment Duplicating a Database with RMAN
thanks. Let's say paths are : /u01/app/oracle/backups/autobackup , /u01/app/oracle/backups/backupset. can you give me exactly DUPLICATE command with PARAMETERs?
May
5
comment Duplicating a Database with RMAN
is there any comment related 3rd question?
May
5
comment Duplication Oracle Database to remote host
I was looking that link.But. I'm confused about duplication. if you see any missing/incorrect then please let me know.
May
4
comment Duplicating a Database with RMAN
thanks for your answer. is it very important pfile name? so is that correct? CREATE PFILE = '$ORACLE_HOME\bin\dbs\init.ora' FROM SPFILE; My spfile : spfileDB11g.ora 2 - $ mkdir -p /u01/app/oracle/oradata/DB11G $ mkdir -p /u01/app/oracle/fra/DB11G $ mkdir -p /u01/app/oracle/admin/DB11G/adump $ mkdir -p /u01/app/oracle/archive_logs --> I will create all directories on the remote server. is that correct?
May
4
comment Duplicating a Database with RMAN
Any suggestions?
Apr
24
comment How to clean up duplicate objects in SYS/SYSTEM
@Phil Like you said I have been doing sanity operations before upgrade.
Mar
23
comment Troubleshoot abnormal connections
My DBA had earlier declared that the ports were not from Oracle DB. From the firewall, the abnormal traffic will transmit from the source server at around 11 to 12 O'clock daily and the ports are random. Is there a way to track from source server?
Oct
4
comment Hide column if any value is null or zero via proc sql or view
@gbn -hide column if any value is null or zero.
Oct
4
comment Hide column if any value is null or zero via proc sql or view
@gbn- As you mentioned,If the zeros/nulls are in different columns on different rows,I want to hide the column.I've updated my question.
Sep
18
comment Full Text Search in SQL 2008
Any suggestions?
Sep
16
comment SQL Query Declaration problem
Microsoft SQLServer 2008.
Sep
13
comment SQL query to convert columns into rows
@Aaron Bertrand-I've updated my question.
Sep
13
comment Simply SQL Query problem
@devzero-First of all,thanks for your reply.But,I getting an error in 'last' AS t .What might be the problem?
Sep
13
comment SQL query to convert columns into rows
@Aaron Bertrand - First of all,thanks for your interesting.But,when I run SQL Query,I got an error.Msg 8117, Level 16, State 1, Line 2 Operand data type bit is invalid for max operator.
Sep
9
comment How to drop multiple tables with common prefix in one query?
thanks again for your reply.
Sep
9
comment How to drop multiple tables with common prefix in one query?
First of all,thanks for your interesting.I want to ask a question.How can I get name list of all tables before drop multiple tables?
Jun
26
comment Determine Index Compression Candidates Online
I don't know an alternative. Perhaps you might get an alternative from Oracle support. I guess the problem here is that to find the benefit of index key compression you really have to do a lot of work. The analyze must look at the spread of the keys throughout the index and within individual blocks.
Jun
25
comment Duplicate record problem
bernd_k - yes, as you said
Jun
25
comment Duplicate record problem
@bernd_k - As you mentioned,maybe.I just gave an sample output.
Jun
24
comment Cartesian Product SQL / Inserts with multiple Values Clauses
Any suggestions?