Skip to Content

HANA SCHEMA NAME in VIEWS

Schema Name issue

Hi All,

I have 2 schema one is dev and other is test in same database and i did import and export of all object from dev to test .

Now the views on test schema is not right as rightly the view definition is using tables on DEV schema and some view definition is not having schema name defined for the tables. .

Now how do we change the view definition in test schema in such a way it point to tables in test schema ??

PS : I have more than 1500 views and cant manually edit all

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 29 at 09:51 PM

    Hi Dilip

    Use Schema Mapping

    Regards,

    Nag

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 03 at 07:45 AM

    Hi Nag,

    Thanks for the message but i dont see any schema name in Authorization schema ,just to add up this is with in same instance of one database not between 2 different system , thanks

    Add comment
    10|10000 characters needed characters exceeded