orcle 实验三笔记

20. November 2015 笔记 0

SQL> create tablespace orcelddd datafile ‘D:\oracle\product\10.2.0\oradata\orcl
\lsi.dbf’ size 10M extent management local uniform size 5M;

SQL> create tablespace orcelddd datafile ‘D:\oracle\product\10.2.0\oradata\orcl
\lsi.dbf’ size 10M extent management local uniform size 5M;

SQL> drop tablespace orcltab including contents;

SQL> alter tablespace orcltab add datafile ‘D:\oracle\product\10.2.0\oradata\orc
l\3.dbf’ size 10M;

SQL> create undo tablespace orclun1 datafile ‘D:\oracle\product\10.2.0\oradata\
orcl\22.dbf’ size 20M;

SQL> create temporary tablespace erer tempfile ‘D:\oracle\product\10.2.0\orada
ta\orcl\ddgg.dbf’ size 20M extent management local uniform size 16M;

SQL> create tablespace ll datafile ‘D:\oracle\product\10.2.0\oradata\orcl\tt.db
f’ size 100M segment space management manual;

SQL> create tablespace orcltab datafile ‘D:\oracle\product\10.2.0\oradata\orcl\l
ijian.dbf’ size 50M;
conn sys/lijian as sysdba;
shutdown immediate
startup nomount
alter database mount
alter database open
alter database read only
alter database read write
show user
select component,current_size from v$sga_dynamic_components;
alter system set java_pool_size=50M;
show parameter shared_server;
SQL> create tablespace orclteb datafile ‘D:\oracle\product\10.2.0\oradata\orcl\lijiansss.dbf’ size 50M extent management
local uniform size 512K;
SQL> create tablespace orc2lteb datafile ‘D:\oracle\product\10.2.0\oradata\orcl\lijianss.dbf’ size 40M segment space man
agement manual;
create temporary tablespace orceww tempfile ‘D:\oracle\product\10.2.0\oradata\orcl\lijianss.dbf’ size 40M segment space man
agement manual tablespace group temp_1;
alter tablespace ss tablespace group temp_1;
alter tablespace orcle add datafile ‘D:\oracle\product\10.2.0\oradata\orcl\lijiansss.dbf’ size 50M
create undo tablespace orcle datafile ‘D:\oracle\product\10.2.0\oradata\orcl\lijiansss.dbf’ size 50M
alter database datafile ‘D:\oracle\product\10.2.0\oradata\orcl\lijiansss.dbf’ resize 20M;
alter database datafile ‘D:\oracle\product\10.2.0\oradata\orcl\lijiansss.dbf’ autoextend on next 5M maxsize 40M;
alter tablespace orceeee offline;
alter tablespace orceeee online;
alter tablespace ss read only;
alter talbesaoce ss read only;
alter database default tablespace ss;
alter tablespace ss rename to s;
alter tablespace ss begin backup;

alter tablespace ss end backup;
drop tablespace ss including contents
drop tablespace ss includeing content and datafiles cascade constraints;
create bigfile tablespace dd datafile ” size 100M;
alter tablespace ss autoextend on next 10M maxsize unlimited
select tablespace_name,extent_management,allocation_type,contents from dba_tablespaces;
select file_name,blocks,tablespace_name from dba_files;
select tablespace _name,sum(bytes) free_spaces from dba_free_space group by tablespace_name;


Leave a Reply

Your email address will not be published. Required fields are marked *