It's a small comfort humankind is quite inventive to work around physical issues (hydraulic,robot aid,...). Fun thing about support here it that we have to move from our desk periodically.

In...

Personally the road with multiple instances comes close to ms sql server databases. With schema's and tablespaces you're stuck when you need to recover more of them (as you reset...

Not sure if following links helps as they are directed to sqlplus regarding unicode

Interesting link on Oracle unicode[/url]

SQL Snippets: unicode - unicode and SQL*Plus (Windows)

Difficult topic as modern tapedrives can take a lot of feed.

Have a look at the recent article regarding sql server jobs[/url]

Why in sharepoint and not a regular fileserver?

Haypp Christmas,

From job perspective it is probably a benefit knowing more than 1 database. SQL Server is easier to administer as it comes with various tools to do so (and...

Good point. Virtualization has many benefits: easy migration, lab testing, flexible in hardware resource, not so dependent on hardware-age

My mayor gripe with virtualization is the licensing model some software vendors...

Thanks for sharing the workaround

I've found an older reference of the problem. You might check the creation script on mixed case.

reference

Otherwise try to setup a trace on the oracleside to see what sql server...

I'm not familiar with crossdatabaseplatform replication. What ora-... error do you get?

Surely there is the need for some thinking time. Many hours of sleep lost when the brain decides to rehearse a memorable problem instead of snoozing.

Could you use code tags?

AND"+

"z.usernameman

concatenates to andz.usernameman which is invalid

Trying to generate dynamic sql?

Also have a look at Quest for SSC alike oracle forums

A point for keeping the modified always filled in >=created date is that your index search on "created or modified within the last 24 hours" works faster (only checking on...