Hi

I created a user by

create user xy identified by xy (and i didnt mention in what tablespace it should get creaed ).
I think it gets created in system tablespace,can i drop that user and recreate it.

I want to know exact syntax

Thanks
lnr