What is a ‘table’ and what is a ‘tablespace’ in Oracle9i? Write an SQL statement to create a tablespace, say MyTableSpace, with default storage. You can use a datafile called ‘MyDataFile.dbf’ for this tablespace.
What will be an ideal response?
A table is a basic conceptual structure that stores data. A table represents an
entity or a relationship.
A tablespace is logical name for a database storage unit that stores related
database objects.
CREATE TABLESPACE MyTableSpace
DATAFILE '\\ict-oracle-s\o$\oracle\oradata\ MyDataFile.dbf' SIZE 5M REUSE
DEFAULT STORAGE (INITIAL 5K
NEXT 5K
MINEXTENTS 5
MAXEXTENTS 100
)
ONLINE;
You might also like to view...
What makes IP spoofing possible for computers on the Internet?
A. network address translation B. the lack of authentication C. the 32-bit address space D. the DNS hierarchy
A large memory ____ is required to print color images and graphics-intensive documents.
A. drive B. capacity C. disk D. card
It is a good idea to use a passphrase and replace some letters with numbers and symbols
Indicate whether the statement is true or false.
Holds a computer system hostage and demands a ransom payment. If _ is on your computer, the data is encrypted and a password is placed on your computer. You then must pay the ransom to receive the code required to retrieve the data.
Fill in the blank(s) with the appropriate word(s).