12,646 reputation
12236
bio website ddbcinc.com
location Rochester Hills, MI
age 38
visits member for 4 years
seen 12 hours ago
Oracle ACE

Jul
23
comment Advanced Replication vs Oracle Streams
@user1524201 - You can certainly configure multi-directional Streams replication if that's what you're asking.
Jul
23
comment Advanced Replication vs Oracle Streams
@user1524201 - If you are simply trying to replicate a subset of rows, you can use a subset rule docs.oracle.com/cd/B28359_01/server.111/b28321/…
Jul
23
comment Advanced Replication vs Oracle Streams
@user1524201 - With a custom apply process, sure, you could. It would generally be easier, though, to replicate the tables (or some subset of rows and columns) locally and then create a view (or materialized view) locally.
Jul
23
answered Query taking long on table with low record count
Jul
23
answered Advanced Replication vs Oracle Streams
Jul
12
answered Are multiple dbf files better than one?
Jul
11
comment In Oracle, how can I give one user privileges to alter the schema of another user?
@Phil - Excellent point-- I read the question initially as trying to avoid giving Dogbert all of Wally's privileges but it was just talking about the password. Updated my answer.
Jul
11
revised In Oracle, how can I give one user privileges to alter the schema of another user?
added 382 characters in body; added 66 characters in body
Jul
11
answered In Oracle, how can I give one user privileges to alter the schema of another user?
Jul
6
comment Flashback feature in Oracle 11g?
Can you simply create the constraints as deferrable, defer them before you issue the DML, and then rollback if the constraints fail to validate at the end of the transaction?
Jul
5
comment When is a row added to DBA_HIST_SQLSTAT?
Is this a RAC database? If you add DBID and INSTANCE_NUMBER to the GROUP BY, are you still getting duplicate rows?
Jul
3
answered How to use simple output parameters?
Jul
2
revised Skip running trigger during cascade delete?
added 150 characters in body
Jul
2
answered Skip running trigger during cascade delete?
Jun
28
comment € Euro sign/symbol not showing up on Oracle 10gr2 and aix 6.1
What is your database character set? What does SELECT * FROM nls_database_parameters WHERE parameter LIKE '%CHARACTERSET' return?
Jun
26
comment Oracle extents - How can I have so many with this small size?
@orbfish - Can you edit your post to include the output from user_extents. Also, post the results of querying user_indexes to get the tablespace_name and dba_tablespaces to get the extent_management and allocation_type for that tablespace. Is this a table that was created in a dictionary managed tablespace that was converted to locally managed?
Jun
26
comment Oracle extents - How can I have so few with this large size?
@orbfish - Can you edit your post to include the output from user_extents. Also, post the results of querying user_indexes to get the tablespace_name and dba_tablespaces to get the extent_management and allocation_type for that tablespace. Is this an index that was created in a dictionary managed tablespace that was converted to locally managed?
Jun
21
comment Oracle - capture row commit order in a table
@Ratnam - Your reader process can hit the change tables, get the SCN from the change table, move it to the sequence_id column of your existing table, and then do whatever else you need to do with the data in the change table to move it into your existing architecture. It's a bit messy but doable. Your reader process could also be a Streams consumer and do the same thing (grabbing the SCN from the Streams change record rather than the CDC change table).
Jun
21
answered delimited values in a column value
Jun
20
comment Oracle - capture row commit order in a table
@Ratnam - Normal CDC involves the reader process controlling a window that shows one change set at a time, consuming that change set, and then advancing the window. The reader consumes data in commit order and never needs to know specifically what the SCN of a change is. You can hit the change tables directly as well to get the actual SCN if you want to complicate the reader's pull process. I'm not sure what "let us know what the maximum sequence_id on its side" means here-- I'm not sure what "us" refers to and I'm not sure what the sequence_id column has to do with anything.