You are hereCreate user on Oracle DB
Create user on Oracle DB
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
Post new comment