Does Golden Gate support Table name starting with number? [message #621785] |
Mon, 18 August 2014 06:02 |
|
Kaustubham
Messages: 5 Registered: August 2014
|
Junior Member |
|
|
Hello
We are trying to replicate data from SQL Server to Oracle and facing issue while replicating data from table having it's name starting with number - 01520Appdata
I tried using using various syntax but it did not work for me.
I got the issues on the Source side (of course target side is out of question at this stage)
Following are few options I tried :
Case 1: using dbo."01520Appdata" for adding trandata & for extract and pump parameter files
Added trandata using dbo."01520Appdata" - Successful
mentioned dbo."01520Appdata" in extract & pump parameter files - Extract abended with error as - "ERROR OGG-00899 Table dbo.dbo.01520Appdata does not exist"
Case 2: using dbo."01520Appdata" for adding trandata & "dbo.01520Appdata" for extract and pump parameter files
Add trandata using "dbo.01520Appdata" - Failed with error - ERROR: No tables found matching 'dbo.dbo.01520Appdata'
so used dbo."01520Appdata" to add trandata
mentioned "dbo.01520Appdata" in extract & pump parameter files - Even after couple of inserts the dat file as well as rpt file were Not updated - No error, No trail file update for data generation
Case 3 : using "01520Appdata" for adding trandata & for extract and pump parameter files
Added trandata using "01520Appdata" - Successful
mentioned dbo."01520Appdata" in extract & pump parameter files - Extract abdended with error as - "ERROR OGG-00899 Table dbo.dbo.01520Appdata does not exist"
Unfortunately the following link do not have mention of this scenario
http://docs.oracle.com/cd/E35209_01/doc.1121/e29397.pdf
Any suggestions, please?
Thanks and Regards
Kaustubham
|
|
|
|
Re: Does Golden Gate support Table name starting with number? [message #621827 is a reply to message #621786] |
Mon, 18 August 2014 14:05 |
babuknb
Messages: 1736 Registered: December 2005 Location: NJ
|
Senior Member |
|
|
Is that schema replication or table replication ?
Can you post your source & target EXTRACT parameter file as well as PARAM file ? I want to make sure where you used doublequote
From Page 30 in Given link .
Quote:MAP "fin"."accTAB", TARGET "fin"."accTAB",
COLMAP ("Account" = "Acct",
"Balance" = "Bal",
"Branch" = "Branch");
-- Get INSERT operations
GETINSERTS
-- MAP statement to map source objects to target objects and
-- filter to apply only the 'NY' branch data.
MAP "fin"."teller", TARGET "fin"."tellTAB",
WHERE ("Branch" = 'NY');
Note the use of single and double quote marks in the Replicat example in Figure 5. For
databases that require quote marks to enforce case-sensitive object names, such as Oracle,
you must enclose case-sensitive object names within double quotes in the parameter file as
well. Note that to specify case-sensitive column names in double quotes, you must use the
USEANSISQLQUOTES parameter in the GLOBALS file; otherwise strings in double quotes are
interpreted as literals. For more information about specifying names and literals, see
"Specifying object names in Oracle GoldenGate input" on page 37
thank you, Babu
|
|
|
|
|