335 reputation
18
bio website
location Paris, France
age
visits member for 5 years, 5 months
seen Dec 11 at 8:31

May
10
comment Oracle: how to find out storage space used by a table?
@Codek: correct, this is only the space used by the table itself. You can calculate the space used by the indexes by the same method however (since indexes are segments and have extents).
Oct
13
comment Oracle import fails due to NLS_DATE_LANGUAGE setting
It could be that even if you set NLS_LANG correctly, it won't set the NLS_DATE_FORMAT or NLS_TIMESTAMP_FORMAT correctly. Is the failing statement a CREATE TABLE? If it is, could you run the statement before the import?
Oct
12
comment Oracle import fails due to NLS_DATE_LANGUAGE setting
You could edit the value in the windows registry (HKLM/SOFTWARE/Oracle/[your oracle home]/NLS_LANG)
Mar
24
comment import XML to Oracle 10g
@equinox: yes, if you can upload your file via FTP to the server you could use this method
Mar
23
comment import XML to Oracle 10g
@equinox: the directory object points to a directory on the server itself. You must upload your file on the server somehow: this is a server-side method, not a client-side one.
Mar
23
comment import XML to Oracle 10g
@equinox: You would create the directory Object in Oracle, then move the file in said directory using your operating system.
Mar
8
comment how modify username in oracle
@benoit: I was really curious to see if it's possible to rename a schema, but it looked too easy :)
May
31
comment Oracle 11gR2: NLS_CHARACTERSET accidentally removed with an UPDATE-Query
@Marco Nätlitz: think of SYS in Oracle as root in Linux/UNIX. Would you recover from a rm -rf / :) ?
May
19
comment Oracle: 1 Large Server vs. 2 Smaller Servers?
+1, although to be exact you can setup a small RAC with a Standard licence (upto 4 sockets, see here: oracle.com/us/products/database/product-editions-066501.html)
Sep
11
comment ORA-27101: shared memory realm does not exist
Do you close the database at night to back it up ?
Aug
26
comment Disconnecting an Oracle Session from a Logon Trigger
@Andrew: I updated my answer: apparently the trigger won't disconnect the OWNER of the trigger.