Real Time Training - Week-1(Day 1 - 5)

Day - 5(Exercise)

1. Create a Tablespace as USER_DATA having two Datafiles as User_Data01,user_data02 ?

2. Create a table(only structure) using scott user(using CTAS method from all_objects) in user_data01 datafile and should be in tablespace user_data ?

3. Insert data from all_objects but data should be available at user_data02 ?

4. Verify the same ?

5. Rename the user_data02 to user_data03.dbf ?

6. Create tablespace with two datafile and create a table on that tablespace. how will you check that table stored into which datafile ?

7. Datafile size is full after reduce the datafile size without losing data ?

8. Create 2 users with password and without assign default tablespace then connect to user create but don't use resource ?

9. Create new tablespace and move the table to that new tablespace ?

10. Create a table on tablespace and find the size on particular user ?