conn sys@bilalEE as sysdba; Enter password: create user testspace identified by test; grant resource, connect to testspace; conn testspace/test@bilalEE create table tspace as select * from all_objects; create table tspace_p partition by hash (owner) as select * from all_objects;