|
create tablespace
بسم الله الرحمن الرحيم
سوف نتحدث اليوم عن جزء مهم جدا في الأوراكل tablespace
A tablespace is a logical storage unit within an Oracle database. It is logical because a tablespace is not visible in the file system of the machine on which the database resides. A tablespace, in turn, consists of at least one datafile which, in turn, are physically located in the file system of the server. Btw, a datafile belongs to exactly one tablespace. Each table, index and so on that is stored in an Oracle database belongs to a a tablespace. The tablespace builds the bridge between the Oracle database and the filesystem in which the table's or index' data is stored. There are three types of tablespaces in Oracle:
Permanent tablespace
create tablespace ts_something
logging
datafile '/dbf1/ahmed.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
Temporary tablespace
create temporary tablespace temp_mtr
tempfile '/dbf1/ahmed.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
Undo tablespace
create undo tablespace ts_undo
datafile '/dbf/ahmed.dbf'
size 100M;[/left][/center]
بعد الأنشاء لمشاهدة tablespace استخدم الأمر الأتي
select tablespace_name,status,content from dba_tablespace ;
او
select tablespace_name,status,content from user_tablespace ;
ولنا عودة انشاء الله
لاتنسونا من صالح الدعاء
ود الطيب
|
العرض العادي
