| Change of used schema [message #220872] |
Thu, 22 February 2007 08:21  |
rosarr
Messages: 2
Registered: February 2007
Location: Frankfurt Germany
|
Junior Member |
|
|
Hello,
Due to a switch to a new server (merging 2 servers) my application schema name has changed from <app_schema> to <site_app_schema>. Still the forms (Forms 9i on a OAS) should continue to be usable.
I found that just changing the data source name in the data block is not enough. What did I forget ?
Thanks in advance for the answer.
Greetings
Ralf
|
|
|
|
|
|
|
|
| Re: Change of used schema [message #221080 is a reply to message #221008] |
Fri, 23 February 2007 12:36  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Why does the fact that there are many schemas in your database implies 'schema.table' notation? When you wrote the application, before anyone started to work with it he/she had to connect to specific schema providing username and password. It means that, at a time, it is possible to connect to only one schema. Right? If you had to use tables/whatever owned by other users, you could have created synonyms and use them.
Unfortunately, I wouldn't know how to help you ... perhaps there's a (free?) utility (search the Internet) which is capable of changing a string in (all?) files in a directory in one pass. You know, something like What to change? -> app_schema.
Change to what? -> site_app_schema. |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
