oracle数据库常见问题答疑（FAQ Oracle database FAQ）.docVIP

oracle数据库常见问题答疑（FAQ Oracle database FAQ） FAQ Oracle database FAQ Author: Ding Cheng and other delivery time: 2003.06.04 15:23:53 Oracle database with its powerful function and stability is known, but at the same time, in the development and management there are many difficulties, the author summarizes some common problems of Oracle database development and management, we hope to help. Q: if you find a bad block in your table, how do you retrieve the other bad data? Answer: first you need to find the bad block of ID (you can run the dbverify Implementation), assuming 1234. Run the query below to find the segment name: Select, segment_name, segment_type, block_id, blocks From dba_extents Where (1234, between, block_id, and (block_id + blocks - 1)); Once a bad segment name is found, if the paragraph is a table, it is better to create a temporary table to store the data. If the segment is an index, delete it and rebuild it. Create table good_table As Select from bad_table where ROWID not in apparatus (select / +index apparatus (bad_table, any_index) / ROWID apparatus From, bad_table, where, substr (ROWID, 1, 8) = 1234) Q: how do I close the small window when FORM calls REPORT? Answer: in the process of using Oracle Develop 2000 database design interface, when FORM calls REPORT, will display a background window REPORT BACKGROUD ENGINE, waiting for FORM to call the REPORT, when FORM calls to other REPORT, also use the backend server, not on the number of REPORT calls, the background server and only one. But when both FORM and REPORT have exited, the window is still waiting and will not be closed, when we need to manually close it. We can use the following parameters not to display this small window when FORM calls REPORT: Add_Parameter (pl_id,ORACLE_SHUTDOWN, TEXT_Parameter,Yes); Note that this parameter must be added to the front of all parameters, that is, it must be the first parameter. Q: how can I dynamically display the records in REPORT according to the query condi