oracle °²×°Ö®ºó

Ò»¡¢²ÎÊýÉèÖÃ
--1¡¢ÉèÖÃA£º
db_block_size = 8192
db_domain = ''
db_file_multiblock_read_count = 16
db_name = bidata
db_recovery_file_dest = /export/home/app/oracle/oracle/product/10.2.0/db_1/flash_recovery_area
db_recovery_file_dest_size = 10737418240
dispatchers = '(PROTOCOL=TCP) (SERVICE=bidataXDB)'
filesystemio_options = SETALL
job_queue_processes = 10
log_archive_dest_1 = ''
log_buffer = 14329856
open_cursors = 1300
optimizer_mode = RULE
parallel_max_servers = 160
pga_aggregate_target = 2097152000
processes = 1000
remote_login_passwordfile = EXCLUSIVE
sga_max_size = 9445572608
sga_target = 4731174912
shadow_core_dump = PARTIAL
shared_memory_address = 0
shared_pool_reserved_size = 13421772
shared_pool_size = 838860800
transactions = 1215
--2¡¢ÉèÖÃB£º
db_block_size = 8192
db_domain = ''
db_file_multiblock_read_count = 16
db_name = bidata
db_recovery_file_dest = /opt/oracle/flash_recovery_area
db_recovery_file_dest_size = 2147483648
dispatchers = '(PROTOCOL=TCP) (SERVICE=bidataXDB)'
job_queue_processes = 10
log_archive_dest_1 = ''
nls_language = SIMPLIFIED CHINESE
nls_territory = CHINA
open_cursors = 300
pga_aggregate_target = 5143265280
processes = 1000
remote_login_passwordfile = EXCLUSIVE
sessions = 1105
sga_target = 15435038720
shared_pool_size = 1258291200
¶þ¡¢Öؽ¨ÁÙʱ±í¿Õ¼ä
--1¡¢¹ÜÀíÔ±µÇ¼
sys/sys as sysdba
--2¡¢´´½¨ÁÙʱ±í¿Õ¼ä
create temporary tablespace TEMP2 TEMPFILE '/oradata/bidata/v2/temp2.dbf' SIZE 20M REUSE;
--3¡¢ÐÞ¸ÄĬÈÏÁÙʱ±í¿Õ¼ä
alter database default temporary tablespace temp2;
--4¡¢É¾³ýϵͳ֮ǰʹÓõÄÁÙʱ±í¿Õ¼ä
drop tablespace temp including contents and datafiles;
--5¡¢°´ÕÕÐèÒªÖØд´½¨ÁÙʱ±í¿Õ¼ä
CREATE SMALLFILE TEMPORARY TABLESPACE "TEMP"
TEMPFILE '/oradata/bidata/v2/TEMP01.dbf' SIZE 10240M,
         '/oradata/bidata/v2/TEMP02.dbf' SIZE 10240M,
         '/oradata/bidata/v2/TEMP03.dbf' SIZE 10240M
EXTENT MA