数据库语句积累.docxVIP

2008-11-19 HYPERLINK /blog/ oracle数据库语句积累一 1、分析表analyze table mzbs.db_code ESTIMATE STATISTICS SAMPLE 20 PERCENT;2、表空间管理和用户管理--查看表空间和数据文件select file_name,tablespace_name,autoextensible from dba_data_files;--数据表空间CREATE TABLESPACE USER_DATA ??? LOGGING ??? DATAFILE D:\ORACLE\ORADATA\ORCL\test.DBF SIZE 50m REUSE ,???????????? c:\USERS01112.DBF SIZE 50m REUSE? ??? AUTOEXTEND ??? ON NEXT? 1280K MAXSIZE? 16383M EXTENT MANAGEMENT LOCAL--修改表空间数据文件的路径ALTER TABLESPACE app_data? RENAME??? DATAFILE?/DISK4/app_data_01.dbf??? TO???/DISK5/app_data_01.dbf;ALTER DATABASE? RENAME FILE /DISK1/