Skip to Content
0

HANA SCHEMA NAME in VIEWS

Mar 29 at 12:11 PM

62

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Nagaraj G Mar 29 at 09:51 PM
0

Hi Dilip

Use Schema Mapping

Regards,

Nag

Share
10 |10000 characters needed characters left characters exceeded
Dilip Deenadayalan Apr 03 at 07:45 AM
0

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


wided.png (36.9 kB)
Share
10 |10000 characters needed characters left characters exceeded