Activity overview
Latest activity by mafujosh
problem: syncing table when name is same as synonym
fyi
(in version 1.0.0.691)
Maybe you have this already handled in a newer release, but in case you don't:
When I am syncing a missing table into my database, it errors with "ORA-00955: name is alre...
feature suggestion - ignore INITIAL value for storage
Feature suggestion:
It would be helpful for me to ignore the "INITIAL" value for storage, but not the TABLESPACE name.
actually it is happening with my char fields also / comments
actually it is happening with my char fields also
easter egg bug or evil trick
The 15 puzzle easter egg is not always solvable. (Google "Sam Loyd's unsolvable 15-puzzle")
FYI, I'm using v1.0.0.667, and only scored 1120 on Oracleoids, but still trying... / comments
FYI, I'm using v1.0.0.667, and only scored 1120 on Oracleoids, but still trying...
I retrieved the fields as in the following query: SELECT
column_name
, data_type
, data_length
, character_set_name
, char_used
, char_col_decl_length
, char_length
, nls_charset_decl_len(data_length, nls_charset_id(character_set_name)) decl_char_len
FROM all_tab_columns
WHERE ...
The correct database returned the following results:
ID VARCHAR2 50 CHAR_CS C 50 50 50
The incorrect database returned the following results:
ID VARCHAR2 150 CHAR_CS C 150 50 150
In Oracle SQL Developer, and likely in the scripts used to create this table in both databases, both databases show this column as varchar2(50 char). The "50" seems to only match if the "char_length" value is used.
Every varchar2 column in every table has this problem. The "char" fields seem to be ok. / comments
I retrieved the fields as in the following query:SELECT
column_name
, data_type
, data_length
, character_set_name
, char_used
, char_col_decl_length
, char_length
, nls_charset_decl_len(data...
bug - varchar2 character count is triple its correct value
Thought I should share this with you in case you aren't aware of it yet:
I am comparing 2 Oracle10g databases. 1 in the U.S. with English settings / Windows 2003, and the other in Japan in Linux p...