Reputation
13,605
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 23 38
Newest
 Caucus
Impact
~714k people reached

Oct
24
comment Oracle Imp Dump Full
Are you just looking for a Yes/No answer (which would be "yes"). Or is there more to your question?
Oct
22
answered How much does an index need to narrow the results of a search in order to be useful?
Oct
19
answered How do Savepoints work in Oracle?
Oct
18
answered Using the same sequence twice in a PL/SQL statement
Oct
18
answered Node and Instance Relationship on Oracle RAC
Oct
16
answered Dropping indexes and disk space
Oct
16
revised Why use explicit cursors instead of regular loops?
added 937 characters in body
Oct
16
answered Why use explicit cursors instead of regular loops?
Oct
15
awarded  Civic Duty
Oct
9
comment Synchronising SQL tables in two locations
You've tagged this for both Oracle and SQL Server. Does that imply that one of the two databases in question is Oracle and the other is SQL Server? Bidirectional replication is made much more challenging if you are trying to work with a heterogeneous environment. Is there some way to identify changes (say, for example, a timestamp column in every row of every table)? Does your request for ANSI SQL solutions imply that you want to roll your own replication process rather than using one of the many replication tools out there?
Sep
27
comment Query missing one date; only happened today
@goober - It is unlikely that there are meaningful performance differences between the alternatives so whatever option is the most readable to you would be preferred. You would want to do a UNION ALL rather than a UNION.
Sep
27
revised Query missing one date; only happened today
added 559 characters in body
Sep
26
answered Query missing one date; only happened today
Sep
26
answered Oracle sequence generation performance during persists of large data sets
Sep
25
awarded  oracle-11g-r2
Sep
24
answered INDEX Creation Advice Oracle
Sep
24
comment INDEX Creation Advice Oracle
I'm not sure I understand the question. You talk about an existing index but you don't tell us what column(s) the existing index is defined on. I'm not sure what you mean by "index type" in the context of your new index-- are you asking whether to create a b-tree index or a bitmap index, whether to create a local index or a global index, or are you asking something else. And then you state that you don't have enough space to build the index (which implies that you know what sort of index you want to build) which implies that you want to know how to make the index smaller.
Sep
24
revised Error “cannot connect to server” installing MongoDB on Ubuntu
added 127 characters in body; edited title
Sep
21
awarded  Custodian
Sep
20
comment How do I import a dump for a deleted tablespace?
You'll need to put double quotes around the source tablespace name in your impdp command since the tablespace name appears to be case sensitive.