Reputation
13,070
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 23 37
Newest
 Enlightened
Impact
~647k people reached

Apr
25
comment how can you determine the exact time for a daily Scheduled Jobs on Oracle
Are you asking how to determine when the job is scheduled to run? Or when it will actually run? Is it scheduled using dbms_job? dbms_scheduler? Something else?
Apr
24
comment Pointing SOA10g to OUD
So, presumably, you're getting some sort of error with some specific error code and error stack when you do some specific operation in some piece of software. Since you've told us nothing about what you've done, nothing about the error you're getting, etc. this question is completely unanswerable.
Apr
24
comment How to track DML and DDL daily events
If you want to know what data changed in the table, you'd need to enable auditing or create triggers to track the changes depending on what exactly you're looking for.
Apr
24
comment How to track DML and DDL daily events
What would it mean to you to report on changes to an index? An index is defined on a table so any change to an indexed column of the table would necessitate index maintenance operations. Those operations might affect the index entries of many different rows in the table (a 50/50 split of a leaf block for example). If all_tab_modifications is giving you the information you want about tables, why do you list tables again in your list of objects you're looking for more information about?
Apr
22
comment How to exceute view without DBLink in oracle server
You don't. I assume you are saying that you have a client application (i.e. SQL Developer) that can connect to each database. If there is no database link, you can't join data between the two short of writing client-side code that fetches all the data from each table and implements join-like logic on the client. That is generally very slow.
Apr
16
comment Multi Tenant Identity
Why would you want to? If you're using an auto_increment, you're generating a synthetic primary key. By definition, that means that the key isn't meaningful for anything other than identifying the row. Why would you care if one tenant sees more than the expected number of gaps in the record_id for a single tenant if the record_id isn't meaningful?
Apr
11
answered is high cpu a bad thing
Mar
19
comment SQL - Optimize table population with dynamic queries
Are you saying that it will loop 1 million times each time inserting 10,000 rows so that it inserts a total of 10 billion rows? Or are you saying that it inserts a total of 1 million rows? Is there a reason that you're looping in the first place rather than simply dynamically constructing the entire INSERT SELECT statement? Do you need the interim commits?
Mar
12
comment Continuous replication between Oracle Database and Microsoft Azure SQL
Why do you believe that GoldenGate is deprecated? Oracle purchased the company and its direction in the future is based on GoldenGate technology (plus bits from Streams).
Mar
11
comment Stored Procedure result is not showing in Datagrid pane in Toad for Oracle
p_recordset is a local variable that goes out of scope as soon as the procedure returns. If you want an object that executes a query and returns a sys_refcursor you probably want a function not a procedure. If you really want to use a procedure, you'd need to add an OUT parameter of type sys_refcursor (or types.cursor_type if that is something meaningfully different).
Mar
9
reviewed Approve Concept of Cardinalilty in Oracle
Mar
6
comment Improve sql server lookup table performance
What does the query plan look like? What does "very slow" mean (minutes? hours?)? What sort of performance are you hoping to achieve? A single-table query using a single IN list predicate with 1000 values should just do 1000 index seeks using the primary key index which should be pretty efficient (though that's relative-- if you're counting milliseconds, efficiency is relative).
Mar
3
answered Why does Oracle indicate my table is using so little space?
Mar
2
revised ON DELETE CASCADE not deleting entry for foreign key
added 56 characters in body
Feb
28
comment How to perform same DML statements on two different servers (Oracle and SQL-Server) simultaneously
Do you really mean simultaneously? So every transaction will incur the overhead of a two-phase commit and the system will be unusable if either database is unavailable? Generally, that's not what you want. Generally, you want to replicate data from one system to the other asynchronously which brings up the question of what sort of lag you can tolerate and whether the replication needs to be bidirectional.
Feb
26
comment How to Load Special characters in Database 11.2 & Client Character Set is US7ASCII through SQL * Loader
Are you trying to load the characters into a varchar2 column? Or an nvarchar2 column? If the database character set is US7ASCII and the "special characters" are not part of the 7-bit ASCII character set, they cannot be validly encoded in a varchar2 column.
Feb
19
answered How to prevent users other than DBAs from creating database links
Feb
17
comment Oracle: Inserting data using a database link
@KellyCook - The error you are getting cannot possibly be the result of something being wrong on the client machine (assuming that it is actually the INSERT statement that throws the error). The error you're getting indicates that the database link is set up incorrectly.
Feb
17
answered Oracle: Inserting data using a database link
Feb
17
comment Oracle: Inserting data using a database link
Are there three machines involved here? A client machine, a machine for DB1, and a machine for DB2? Do you have one machine with three Oracle Homes (one for the client, one for the DB1 database, and one for the DB2 database)? It seems unlikely that you'd do an Instant Client install on a machine that is already running the database so I'm guessing multiple machines are involved. If so, the tnsnames.ora file that needs to have DB2's connection information would need to exist on the machine (and Oracle Home) running DB1. Your client's TNS settings are irrelevant.