Shulou(Shulou.com)06/01 Report--

1. ALTER DATABASE MOVE DATAFILE

Data files can be migrated online to a new path, and system tablespaces can be move.

SYS@czh29c > alter database move datafile'/ oradata/czh29c/ORCL/czhpdb1/system01.dbf' to'/ oradata/czh29c/system01.dbf';Database altered.SYS@czh29c > alter database move datafile'/ oradata/czh29c/system01.dbf' to'/ oradata/czh29c/ORCL/czhpdb1/system01.dbf';Database altered.2.CREATE LOCAL TEMPORARY TABLESPACE

RAC is more suitable for creating local temporary tablespaces. Different nodes can use local directories and their own temporary tablespaces.

Oracle uses temporary tablespace order:

Shared temporary tablespace-> local temporary tablespace-> system tablespace

SYS@czh29c > create local temporary tablespace for all test_local tempfile'/ oradata/czh29c/ORCL/czhpdb1/test_local01.dbf' size 100m autoextend off;Tablespace created.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.