Oracle issues, 10 questions per day (vi)

oracle| problem
51. How do I put a small table in a keep pool?　　ALTER TABLE XXX storage (buffer_pool keep);　　52. How do I check if a patch is installed? Check that Orainventory 53.　　How do I make a SELECT statement automatically generate ordinal numbers for query results?　　Select Rownum,col from table;　　54. How do I know the tablespace of a table in the data pants?　　Select Tablespace_name from User_tables where table_name= ' TEST ';　　There is a field in the select * from User_tables 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 under Sqlplus?　　Select Line,trim (text) t from User_source where name = ' an ' order by line;　　56. How to remove procedure is accidentally locked?　　Alter system kill session, the session will be killed, but you have to find out her session ID or the process to change the name on it.　　What is SQL reference?　　is a manual of SQL, including syntax, functions, and so on, which is downloaded from the Documentation Center of the official Oracle website.　　58. How do I view the status of the database? Unix under Ps-ef | grep ora windows to see if the service is up and can connect to database 59.　　How can I 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? With ALTER DATABASE ....　　DataFile ...; Manually changing the size of the data file, there is no damage to the original data file.