search

is00hcw / tungsten-replicator

Automatically exported from code.google.com/p/tungsten-replicator
0 stars 1 forks source link

setupCDC.sh should force the use of upper case for Oracle user name #1085

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Not using upper case will lead to the script not identifying tables to process :

SELECT table_name FROM ALL_TABLES where owner='example'

will show 0 row result, whereas 

SELECT table_name FROM ALL_TABLES where owner='EXAMPLE'

would show the expected number of rows.

Original issue reported on code.google.com by stephane...@continuent.com on 13 Jan 2015 at 2:33

GoogleCodeExporter commented 9 years ago

Original comment by linas.vi...@continuent.com on 13 Jan 2015 at 3:53

GoogleCodeExporter commented 9 years ago 
This issue was updated by revision r2765.

Now upper-casing Oracle USER names

Original comment by stephane...@continuent.com on 15 Jan 2015 at 3:20

GoogleCodeExporter commented 9 years ago 
This is now fixed

Original comment by stephane...@continuent.com on 15 Jan 2015 at 3:21

GoogleCodeExporter commented 9 years ago 
This issue was updated by revision r2767.

Upper-casing Oracle USER names by using awk
(Previous syntax was failing depending on the BASH version)

Original comment by stephane...@continuent.com on 16 Jan 2015 at 8:10

GoogleCodeExporter commented 9 years ago

Original comment by linas.vi...@continuent.com on 19 Jan 2015 at 2:19