tablespace - Lab Exercise

    1)Create a tablespace called USER_DATA with two data files named User_Data01 and User_Data02.
    

    2)Datafile size is full after reduce the datafile size without losing data

    

    3)Check undo tablespace size and name
    

    4)Create undo tablespace and assign it as default undo tablespace
    

    5)Create new temp tablespace and assign default temp
    

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

    7)Create new  tablespace and move the table to that new tablespace.
    

    8)Create a table on tablespace and find the size on particular user.
    

    9)Move the datafile SYSAUX to another location(online)
    

    10)Move the datafile SYSTEM to another  location (online)
    

    11)Demonstrate the ORA-0555 error