Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
7
Newest
 Commentator
Impact
~2k people reached

Feb
13
comment Any advantage of creating table in temporary tablespace - Oracle
Have to correct myself here. You can create a table that is intent on using a certain tablespace, but can't add anything. (Only then actual segments are created).
Feb
12
awarded  Commentator
Feb
12
comment Any advantage of creating table in temporary tablespace - Oracle
There is a difference between "Global Temporary Tables" and "Temporary tablespaces using temporary datafiles". Your answer is unclear on what you're talking about, although i think most of the statements will be true for both.
Feb
12
comment Any advantage of creating table in temporary tablespace - Oracle
You can. create table example (example number) tablespace TEMP;
Dec
8
awarded  Critic
Sep
16
awarded  Scholar
Sep
16
accepted Optimal way of loading, registering, indexing and querying a huge XMLDB
Sep
5
comment How to replace a CLOB column by a varchar2(4000) column?
nice. Maybe a trim around the substr is useful? and, why use a = NULL if you drop it later?
Aug
26
comment Optimal way of loading, registering, indexing and querying a huge XMLDB
@Raj: Thanks. I had already posted it at XML Database (MOSC), but i've duplicated the post to the other two forums now.
Aug
25
comment Optimal way of loading, registering, indexing and querying a huge XMLDB
Are you aware of any other technology that would be more suitable to transform these XML files into a RDB?
Aug
25
revised Optimal way of loading, registering, indexing and querying a huge XMLDB
small typo
Aug
25
asked Optimal way of loading, registering, indexing and querying a huge XMLDB
Feb
21
comment Ports necessary for Oracle 11g Replication across a firewall?
Ah, a bit like FTP with Passive mode. That would explain OP's issue indeed.
Feb
20
comment Ports necessary for Oracle 11g Replication across a firewall?
I just did a portscan on our server, aside from other services, only port 1521 is open. Also our server firewall blocks anything else... So even if another port is negotiated, this should not work. I could do a packetsniff of an active connection to verify...
Feb
20
comment Ports necessary for Oracle 11g Replication across a firewall?
Are you sure? The client will use a whole range of ports to connect to the listener port, but i was under the impression Oracle only listens on port 1521. Of course, this could be part of the problem, if the outgoing client connections get blocked.
Feb
20
answered Ports necessary for Oracle 11g Replication across a firewall?
Feb
20
awarded  Excavator
Feb
20
answered Database throughful design vs Quick and dirty design comparison
Feb
20
revised How to retrieve disk spaces by removing tables from tablespaces in Oracle 10g?
Added amazingly useful reference
Feb
20
suggested approved edit on How to retrieve disk spaces by removing tables from tablespaces in Oracle 10g?