|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Latest Answer : Yes : Schema objects can stored in different tablespace and a tablespace can contained one or more schema objects data. ... It consists ofone or more data files.one or more control files.two or more redo log files.The Database containsmultiple users/schemasone or more rollback segmentsone or more tablespacesData dictionary Latest Answer : We need to put the tablespaces in backup mode during hot backup so that writing to datafiles related to this tablespace would stop and be written in the archive logs instead during the period of the backup. If you will not put the tablespaces in backup ... Is it possible to resize tablespaces and data files? If yes, how? Latest Answer : Hi all,Yes i agree with the answer but resize in the sense,the size should also get decrease.we can decrease even the size of the datafile but the condition is the datafile should be empty. ... A user has connect and resource privileges allocated by the DBA. He is been allocated quota on three tablespaces by the DBA - Default Tablespace Quota 500 M - Tablespace 1 Quota 100 M - Tablespace 2 Quota Latest Answer : Yes he will be successful. because resource role grant user unlimited tablespace system privilege. quota ignored.
SQL> create user test identified by test1;
User created.
SQL> grant connect, resource to test;
Grant succeeded.
SQL> select * from ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
