-
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
-
>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