How can we help you today? How can we help you today?
mcnamaragio
Activity overview Badges (0) Posts (3) Comments (22)

Comments

Sort by recent activity
Bingo! It works great. / comments
  1. Community
  2. Schema Compare for Oracle
  3. Char detected as byte on production server.
Bingo! It works great.
0 votes
I tried it but the result is same. / comments
  1. Community
  2. Schema Compare for Oracle
  3. Char detected as byte on production server.
I tried it but the result is same.
0 votes
Can you upload it to an http site? I think ftp is blocked here. / comments
  1. Community
  2. Schema Compare for Oracle
  3. Char detected as byte on production server.
Can you upload it to an http site? I think ftp is blocked here.
0 votes
Thanks. I am on vacation and will check it when I'm back in the beginning of August. / comments
  1. Community
  2. Schema Compare for Oracle
  3. Char detected as byte on production server.
Thanks. I am on vacation and will check it when I'm back in the beginning of August.
0 votes
Yes, that information is available to a restricted user. On live server both queries return NLS_LENGTH_SEMANTICS set to BYTE while on the development server it is set to CHAR. / comments
  1. Community
  2. Schema Compare for Oracle
  3. Char detected as byte on production server.
Yes, that information is available to a restricted user. On live server both queries return NLS_LENGTH_SEMANTICS set to BYTE while on the development server it is set to CHAR.
0 votes
Any decision about this topic? / comments
  1. Community
  2. Schema Compare for Oracle
  3. Char detected as byte on production server.
Any decision about this topic?
0 votes
I found that you can get NLS_LENGTH_SEMANTICS from nls_database_parameters and nls_instance_parameters tables. / comments
  1. Community
  2. Schema Compare for Oracle
  3. Char detected as byte on production server.
I found that you can get NLS_LENGTH_SEMANTICS from nls_database_parameters and nls_instance_parameters tables.
0 votes
What do you suggest? Perhaps you can add two modes of comparison? strict and not so strict ? / comments
  1. Community
  2. Schema Compare for Oracle
  3. Char detected as byte on production server.
What do you suggest? Perhaps you can add two modes of comparison? strict and not so strict ?
0 votes
When I view the table sql in pl/sql developer I see the same script so for me the two tables are identical. I think CHAR_USED being different it's caused by server configuration differences so I want to ignore it. I found 'show parameter NLS_LENGTH_SEMANTICS' command but I can't execute it on the production server. I think that the tool should either ignore differences if NLS_LENGTH_SEMANTICS reports different result or have an option to ignore it manually. / comments
  1. Community
  2. Schema Compare for Oracle
  3. Char detected as byte on production server.
When I view the table sql in pl/sql developer I see the same script so for me the two tables are identical. I think CHAR_USED being different it's caused by server configuration differences so I wa...
0 votes
You are right but why does PL/SQL developer show the same script on both servers? / comments
  1. Community
  2. Schema Compare for Oracle
  3. Char detected as byte on production server.
You are right but why does PL/SQL developer show the same script on both servers?
0 votes
Total activity
29
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
4