Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the relationship among Database, Tablespace and Data
file?
- 4 Answers
- 12764 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chaudhry
Each databases logically divided into one or more
tablespaces One or more data files are explicitly created
for each tablespace.
| Is This Answer Correct ? | 8 Yes | 2 No |
Each data base is divided into logical units called table
spaces and each table space is again divided into segments.
Data files are created for table spaces.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nishi
database contain atleast one tablespace and tablespace must have atleast one datafile
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / riddhi
An Oracle database consists of one or more logical storage
units called tablespaces.
tablespaces is consist of one or more datafiles.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the factors causing the reparsing of SQL statements in SGA?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What are the original export and import utilities?
How to estimate disk space needed for an export job?
Explain the use of indexes option in exp command.
How can we Update a table with out using UPDATE command?
Explain about functional dependency and its relation with table design?
create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......
How to pass a cursor variable to a procedure?
Explain about integrity constraint?
What is the difference between column level constraints and table level constraints?
14 Answers IBM, TCS,
How to open a cursor variable?
Oracle General 
