special character in Oracle schema owner name

bayne1j · Post by **bayne1j** » Mon Oct 09, 2006 6:28 am

I have to load a table into an oracle database where the schema owner ID contains a $. As the Oracle userID that I am using does not own the table, I have to prefix the table name with the schema owner name in the Oracle Enterprise stage.

When I run the job it fails with the following error:

main_program: Fatal Error: Invalid character $ encountered in table OPS$OWNER.TABLENAME

I have tried adding the environment variable DS_ENABLE_RESERVED_CHAR_CONVERT and setting this to true but this does not seem to work for special characters in the table owner name.

Any ideas?

J

ray.wurlod · Post by **ray.wurlod** » Mon Oct 09, 2006 3:51 pm

Welcome aboard. :D

Try surrounding the owner name in double quotes. For example "OPS$OWNER".TABLENAME

bayne1j · Post by **bayne1j** » Tue Oct 10, 2006 1:48 am

Thanks for the reply.

I have tried surrounding in quotes but still get the same error

thumsup9 · Post by **thumsup9** » Tue Oct 10, 2006 7:59 am

ray.wurlod wrote:Welcome aboard. :D

Try surrounding the owner name in double quotes. For example "OPS$OWNER".TABLENAME

what happens when you SET QUOTED_IDENTIFER ON and then use the above example suggested by Ray

thumsup9 · Post by **thumsup9** » Tue Oct 10, 2006 8:12 am

ray.wurlod wrote:Welcome aboard. :D

Try surrounding the owner name in double quotes. For example "OPS$OWNER".TABLENAME

what happens when you SET QUOTED_IDENTIFER ON and then use the above example suggested by Ray

bayne1j · Post by **bayne1j** » Tue Oct 10, 2006 9:38 am

Is QUOTED_IDENTIFIER an environment variable? I can't seem to find it....