Reputation
355
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 8
Newest
 Custodian
Impact
~75k people reached

  • 0 posts edited
  • 1 helpful flag
  • 38 votes cast
Mar
12
comment Oracle: how to find out storage space used by a table?
@pacoverflow sure, use UNION ALL for instance.
Mar
4
comment Oracle: how to find out storage space used by a table?
@pacoverflow good point !
Oct
30
awarded  Custodian
Oct
30
reviewed Edit Oracle: how to find out storage space used by a table?
Oct
30
revised Oracle: how to find out storage space used by a table?
replaced French "Mo" by English "MB" (megabyte)
May
21
awarded  Caucus
Jul
24
revised Oracle import fails due to NLS_DATE_LANGUAGE setting
deleted 10 characters in body
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
awarded  Commentator
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)
Oct
11
answered Oracle import fails due to NLS_DATE_LANGUAGE setting
Oct
8
awarded  Yearling
Apr
19
answered Does Oracle DB has a tool like DTS Wizard in SQL Server?
Apr
14
answered Is there any viable alternative to using Oracle Auditing
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
23
answered import XML to Oracle 10g
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 :)