185 reputation
5
bio website
location
age
visits member for 2 years, 5 months
seen Sep 16 at 12:18

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 suggested edit on How to retrieve disk spaces by removing tables from tablespaces in Oracle 10g?
Feb
20
answered Tablespace resize in Oracle 10g
Sep
9
awarded  Supporter
Jun
11
comment ARCHIVELOG mode
I'm not sure if it will realy be of use if your DB files become corrupted. Maybe in some cases, but i'm pretty shure you will need your backup if your database files become useless.
Jun
11
comment ARCHIVELOG mode
Also, it is most commonly used in combination with a backup system. Once a new backup has been created, the archived log file is dropped. Otherwise, if the archive log is not set up to rotate, it will keep on growing. The real added value here is that if the database breaks down somewhere past a backup, it can be restored up to the latest point in time by using the archive log files (wich are of course stored on a different machine, for that reason).
May
11
awarded  Teacher