Change table name of table in published view
We have a handful of dimension & fact tables across multiple YF views (used by many production reports & dashboards) where we have a business need to change the table names. The table structures remain the same. Can I change the table name in the view without having to rebuild the views and/or reports?
We use Oracle, so if synonyms can come into play to assist us here, that's an option as well. I'm just trying to determine the scope of this project before I dive in to development.