Red Gate forums :: View topic - Schema Compare 3.0.0.689 - bug report
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Schema Compare for Oracle
Schema Compare for Oracle forum

Schema Compare 3.0.0.689 - bug report

Search in Schema Compare for Oracle forum
Post new topic   Reply to topic
Jump to:  
Author Message
steve B



Joined: 23 Jul 2013
Posts: 4

PostPosted: Mon Jul 29, 2013 3:30 pm    Post subject: Schema Compare 3.0.0.689 - bug report Reply with quote

Bug report:

1. Create comments on the columns of a VIEW in the database (Oracle XE 11.2.0.2.0)
2. Use schema compare v3.0.0.689 to generate scripts - runs OK
3. Use schema compare v3.0.0.689 to re-create objects in database schema from scripts - FAILS

The Schema Compare run in step 3 fails when running deployment script with "Error: ORA-00911: invalid character"

Removing the "comment on column view.column is '...'" commands from the "create view" script seems to fix the problem - so assume that these comments are the cause of the problem.

Could someone please confirm whether
(1) This is a bug?

and

(2) When we can expect a new version of Schema Compare that fixes this (and the 2 previously reported bugs)?
Back to top
View user's profile Send private message
neil.anderson



Joined: 28 Sep 2010
Posts: 64

PostPosted: Wed Jul 31, 2013 11:02 am    Post subject: Reply with quote

Hi Steve,

Thanks for getting in touch. This could be a bug but as ever, it depends. Can you post here or send to oracle@red-gate.com the SQL the Schema Compare is outputting that causes this problem?

I think it could be either we're outputting invalid SQL or the target you are deploying to has a different character set than the source (assuming it is a different database).

Thanks,
Neil
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group