Forum Discussion
Oracle Mirroring - Invalid Identifier Error
apitcher11 This issue could be related to how OneLake handles folder/file naming conventions. All mirrored tables become folders and files in OneLake file system. While the `$` is not specifically prohibited as a part of the folder/file/table name but it may cause problems when interpreted by various Fabric compute jobs. The fact that in a Fabric error message it's replaced with `_` hints that some sanitization technique could have been used. You could try and rename your table without using a `$` to verify. If it's not possible, your only options is to use a data pipeline for ingestions instead of mirroring. I cannot confirm whether mirroring allows you to choose specific columns in the table for mirroring, otherwise try and exclude the column.
That's as much as I could think of and wish you luck.