Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Install instructions for windows81. pc + version for php newbie wishing to use php to access data re

user5716448Apr 6 2017 — edited Apr 10 2017

Hi All,

Have a windows 8.1 pc. New to php and have enabled IIS on pc and now wish to install php in order to use php to connect and pull data from oracle 11.2.0.4 database

Saw a link on microsoft site but only mentioned sql drivers no mention of oracle.

Anyone know of good link/instructions to install as simply as possible and any steps needed afterwards.

Thanks

Comments

Solomon Yakobson

It couldn't unless dropped in both schemas directly or indirectly (e.g. there is after DDL trigger). Also, second schema could have not the view but rather a synonym to first schema view, although in such case you'd get "synonym translation no longer valid" rather than "table or view doesn't exist". You could check DBA_AUDIT_TRAIL to find out who and when dropped what, assuming DDL audit it enabled.
SY.

Kamran Agayev A.

Dear OP
If audit wasn't enabled in the database, it's hard to answer the question "who dropped the view". If the data is still in UNDO, you can use flashbcak query to get the dropped views back. Check the following blog post for more information on this:
How to flashback procedure or package - OracleDocs.com (0 Bytes)BR,
Kamran Aghayev A.

Solomon Yakobson

There is no need to dig into flashback unless OP has no saved view definition script (which would be strange and would indicate much deeper organizational issues).
SY.

Kamran Agayev A.

OP mentioned that views in other schemas were dropped which means that most probably they didn't saved the script of the views which dropped by accident

user545194

enable_ddl_logging is not enabled. We are on SE, therefore do not have flashback query. I can check the alert log to see what happened. Aren't dropped objects moved to the recyclebin?

Solomon Yakobson

If so, then, as I already mentioned, it would indicate much deeper organizational issues. Any changes must be scripted and saved to CMS before deploying.
SY.

Kamran Agayev A.

Views are just scripts which are not moved to the recycle bin. Do you have a test environment for this particular database to imitate the same action there as well and see if views are dropped (which shouldn't )

user545194

Yes, we have a test environment and the views are there, but they are not in sync with the production env. But I can perform the same action and see what the outcome is. For production however, we'll have to restore from a recent backup.
Good news: Suddenly the views "re-appeared" and are visible in the SQL Developer tree view.
Really strange. Thanks to all for your feedback.

Kamran Agayev A.

Sure you have to restore it from backup anyways. What I'm wondering the abnormal behavior that happened in your system. I would suggest you to enable the audit on the test environment, drop the mentioned views and check if other views are also dropped
BR,
Kamran Aghayev A.

user545194
Answer

Yes, I will definitely run this in the test environment. Thanks again!

Marked as Answer by user545194 · Jan 25 2021
1 - 10
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 8 2017
Added on Apr 6 2017
9 comments
724 views