51. How to put a small table in a Keep pool? ALTER TABLE XXX Storage (Buffer_Pool Keep); 52. How to check if a patch? Check what ORAINVENTORY 53 is installed? How to make the SELECT statement automatically generate a serial number? SELECT ROWNUM , COL from table; 54. how do I know tablespace pants in a data table where the select tablespace_name from user_tables where table_name = 'TEST';? select * from user_tables there is a field tABLESPACE_NAME, (oracle); select * from dba_segments where ... ; 55. How can you quickly make a backup table like the original table? Create Table new_table as (select * from old_table);
55. How to modify Procedure? Select Line, Trim (Text) t from User_Source where name = 'a' order by line; 56. How to remove procedure is accidentally locked? ALTER system kill session, kill the session But you have to check that her session ID OR will re-change the name. 57. Is SQL Reference be something? Is a SQL manual, including grammar, functions, etc. Document Center in Oracle official website, download. Upper database 59. How to modify the primary key of a table? Alter Table AAA DROP CONSTRAINT AAA_KEY; ALTER TABLE AAA Add ConsTRAINT AAA_KEY PRIMARY Key (A1, B1); 60. Change the size of the data file? Use Alter Database .... DataFile ....; manually change the size of the data file, there is no damage to the original data file.
