Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Oracle SQL Plus The Definitive Guide- P40:Every day, computer professionals the world over wake up, travel to the office, sit down in front of a computer, and begin another day working with that database called Oracle. Programmers write queries and stored procedures. Database administrators monitor performance, make database changes, and perform other maintenance tasks. Operations people may need to back up or recover a database. | previous page page_356 next page Page 356 If you are responsible for backing up an Oracle database make sure you know how to restore it You should test yourself and your procedures by doing a trial restore of the database to another computer or to another set of directories on the same computer. Many people have found holes in their backup methods only after a disaster forces them to attempt a restoreit s too late then. If you have never restored your database then you do not have a good backup. In order to be prepared for the day when you lose a disk and consequently some critical database files you should become familiar with the information in the Oracle8 Backup and Recovery Guide. You don t need to read it cover to cover but you should be familiar with the concepts and procedures it describes. In addition and I can t emphasize this enough practice recovering your database. I am personally aware of cases where a database could not be recovered because the backups weren t being done correctly. I have even been burned myself. While writing this chapter I discovered to my great chagrin that one of our disk drives was not being backed up each night. I was lucky. I only lost one table with old data that nobody cared about. Next time I may not be so lucky. Practice pays. previous page page_356 next page previous page page_357 next page Page 357 11 Customizing Your SQL Plus Environment In this chapter SQL Plus settings You Can Control The Site and User Profiles Environment Variable Settings The SET Command The SHOW Command This chapter will show you how you can modify the SQL Plus environment in order to make things more convenient for you or for the users you support. There are a number of settings that can be customized. Some like the search path used for SQL scripts are more useful than others. In addition there are two SQL scripts that are automatically run whenever you start SQL Plus. These SQL scripts are useful for example if you have specific SET commands that