- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Invalid views
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-13-2002 06:43 AM
тАО11-13-2002 06:43 AM
Invalid views
i have a production DB 8.1.6.0 that have a lot of invalid views. I want to "clean" the db. I'd like to remove the views, but before doing this, i want to backup them to prevent possible problems. This is a very critical db. However i have a replica of it on another db less critical, so i can try there.
So, steps to follow will be:
- backup invalid views (about 300)
- remove views
- test if everything works
- restore views (2 see if backup is ok)
- remove all again and do it on production db
How can these steps be done technically?
Thanks....
Tarek
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-13-2002 07:06 AM
тАО11-13-2002 07:06 AM
Re: Invalid views
You can use a rows=n export to secure the views (among other things), running an import will recreate them for you.
Regards,
John
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-13-2002 07:24 AM
тАО11-13-2002 07:24 AM
Re: Invalid views
If they're invalid i don't think they're used, but because i'm not sure i want to backup them and try to remove and see what happens.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-13-2002 08:06 AM
тАО11-13-2002 08:06 AM
Re: Invalid views
In sqlplus:
set head off
set feed off
spool xxx.sql
select 'alter view '||view_name|| ' compile;' from user_objects where object_type = 'VIEW' and status = 'INVALID';
spool off
@xxx.sql
Regards,
John
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-14-2002 01:18 AM
тАО11-14-2002 01:18 AM
Re: Invalid views
ALTER VIEW
and then see what errors you get - most likely a referenced table has been dropped or changed.
If you are determined to drop the views I attach a script which will extract a view to a file. Param 1 is the uppercase viewname, in 'single quotes'; optional param2 is the file name.
Good luck.
-- Graham
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2002 03:17 AM
тАО11-26-2002 03:17 AM
Re: Invalid views
alter view view_name compile;
i get
Warning: View altered with compilation errors.
And the status is still invalid.
But i don't know what these views does
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2002 09:36 AM
тАО11-26-2002 09:36 AM
Re: Invalid views
Try using the command 'SHOW ERRORS' immediately after the failed compile to find out what is broken.