Create user on Oracle DB

gistfile1.txt

Here is some SQL query to create an user with default auth:

CREATE USER eyes IDENTIFIED BY eyes DEFAULT TABLESPACE users;
GRANT CONNECT TO eyes;
GRANT RESOURCE TO eyes;

Drop an user:

DROP USER
eyes CASCADE;

Now how to export a DB schema(+data) to a file:

exp eyes/eyes grants=N owner=eyes file=export.dump

And to import back the DB schema from a file

imp userid=eyes/eyes commit=Y file=export.dump fromuser=toto touser=eyes