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 ? |