Reputation
559
Top tag
Next privilege 1,000 Rep.
See vote count; VIP usercard
Badges
4 16
Impact
~33k people reached

  • 0 posts edited
  • 1 helpful flag
  • 37 votes cast
Feb
11
awarded  Nice Question
Jan
29
awarded  Citizen Patrol
Jan
21
awarded  Popular Question
Dec
10
awarded  Notable Question
Oct
2
comment “ORA-00936: missing expression” setting up Oracle Publisher in SQL Server
@BrandonWilliams I updated the question to add my T-SQL code, generated by the publication wizard. All the pre-steps execute without issue, and it's the final step that actually adds the article to the Oracle publication that gives me the error.
Oct
2
revised “ORA-00936: missing expression” setting up Oracle Publisher in SQL Server
added code that causes the issue
Sep
30
comment “ORA-00936: missing expression” setting up Oracle Publisher in SQL Server
@RLF: There's isn't any code, as I'm using the SSMS "Add Oracle Publisher" wizard rather than using T-SQL directly. That said, the error seems to occur when the wizard executes sp_addarticle, which is turn executes sp_ORAaddarticle, from which the code is hidden (because it's a system stored proc). This, in turn, executes a package deployed to the oracle database called "MYUSERNAME.HREPL" where the error is actually occurring. I know that's not much help, but we're sifting through that package now to see if can find the statement.
Sep
30
asked “ORA-00936: missing expression” setting up Oracle Publisher in SQL Server
Jul
28
awarded  Popular Question
Jul
2
awarded  Curious
Jul
1
awarded  Popular Question
May
23
comment Modify an Oracle Dataguard destination database
It's not one trigger - it's one on every table. We're using it as a step to replicate the data to an MSSQL Server, which requires their DDL trigger on every table. Even if it was supported, I don't want to potentially slow down the operations by introducing this kind of load on the production server if I can do it on a native Oracle replica of some kind.
May
23
comment Modify an Oracle Dataguard destination database
We're using it as a stepping stone to replicate into MSSQL Server, which requires that we put a trigger on every single table in the database. It's not something the vendor will support, and not functionality they're interested in adding at this time (I wish it was).
May
23
asked Modify an Oracle Dataguard destination database
Jan
29
awarded  Popular Question
Sep
27
comment Sharing a single primary key sequence across a database?
If you had to choose between something like this and just using uniqueidentifiers as primary keys, would you have a preference (though the answer is likely "it depends")? It seems like a GUID would work around the problem the same way, except that you'd get a standard implementation rather than having to roll your own centralized primary-key-generator. Obviously, using a sequence in SQL 2012 would accomplish both things, but assuming somebody is on an older version?
Aug
26
awarded  Yearling
Aug
1
comment Can I reorganise index on a sql server 2005 database without performance hit on production server
I'm unclear why this was voted down as well - it's something I've used a number of times, and if it's a bad idea, I'd like to know why.
Jul
18
awarded  Notable Question
Jun
15
answered How to run an exe file exists on a different server from SQL Server Job