LONG FILENAMES ORACLE 8I PERSONAL ED.

[treedstang]

I'M CURRENTLY TESTING A REPLICATION PRODUCT ON ORACLE 8I. ONE SYSTEM HAS THE PERSONAL EDITION AND THE OTHER HAS ORACLE 8I ENTERPRISE EDITION.

WHEN ATTEMPTING TO MAP TABLES IN THE REPLICATION SOFTWARE I DISCOVERED THAT SOME OF MY TABLE NAMES AND COLUMN NAMES WERE ABBREVIATED TO 10 CHARACTERS OR LESS .

THEN IT DAWNED ON ME THAT ORACLE 8I PERSONAL ED WAS PROBABLY 16BIT AND THAT WAS CAUSING THE PROBLEM.

IS THERE SCRIPT OR SOMETHING THAT I CAN RUN THAT WILL ALLOW LONG FILENAMES ON ORACLE 8I PERSONAL EDITION WITHOUT REINSTALLING ORACLE. I WOULD USE ORACLE ENTERPRISE ON THIS SYSTEM BUT IT DON'T HAVE ENOUGH RESOURCES TO SUPPORT IT

"THIS IS JUST A TEST BOX I'M USING".

HELP


TIM

[orasbl]

>I'M CURRENTLY TESTING A REPLICATION PRODUCT ON >ORACLE 8I. ONE SYSTEM HAS THE PERSONAL EDITION >AND THE OTHER HAS ORACLE 8I ENTERPRISE EDITION.
>WHEN ATTEMPTING TO MAP TABLES IN THE REPLICATION >SOFTWARE I DISCOVERED THAT SOME OF MY TABLE >NAMES AND COLUMN NAMES WERE ABBREVIATED TO 10 >CHARACTERS OR LESS .
>THEN IT DAWNED ON ME THAT ORACLE 8I PERSONAL ED >WAS PROBABLY 16BIT AND THAT WAS CAUSING THE >PROBLEM.
>IS THERE SCRIPT OR SOMETHING THAT I CAN RUN THAT >WILL ALLOW LONG FILENAMES ON ORACLE 8I PERSONAL >EDITION WITHOUT REINSTALLING ORACLE. I WOULD USE >ORACLE ENTERPRISE ON THIS SYSTEM BUT IT DON'T HAVE >ENOUGH RESOURCES TO SUPPORT IT

If possible, send to me the steps you used to configure this envoronment. I have the same (or as like as) environment, as described above:

Server: Oracle 8i Standard Edition, release 8.1.5 in one HP
Station: PO8i release 8.1.6 in Windows 98

"THIS IS JUST A TEST BOX I'M USING".

I have a same environment for testing pourposes as like yours, too...

Rgds,
Sven