1在PL/SQL中解锁用户并且授予权限的SQL,例如给scott用户解锁:
ALTER
USER
SCOTTACCOUNTUNLOCK;
2 给该用户相应的权限:
grant
connect,
create
table
,
create
view
,
create
any
index
,
create
session
to
scott;
3 在PL/SQL中创建表空间:
SQL
>
create
tablespaceedison
2 datafile ' E:oracleproductedison.ora ' size500m;
Tablespacecreated
SQL > create user hujun
2 identified by SYS;
User created
SQL > grant connect, create table , create view , create any index , create session to hujun;
Grant succeeded
SQL > alter user hujunquota500m on edison;
User altered
SQL > grant dba to hujun;
2 datafile ' E:oracleproductedison.ora ' size500m;
Tablespacecreated
SQL > create user hujun
2 identified by SYS;
User created
SQL > grant connect, create table , create view , create any index , create session to hujun;
Grant succeeded
SQL > alter user hujunquota500m on edison;
User altered
SQL > grant dba to hujun;
4 如果需要在JAVA WEB开发中引用表空间的话最好一句最好不要,因为如果是DBA的话,如果连接参数写在配置文件里(user = hujun as dba),这样程序无法连接到数据库,所以建议不要授权为DBA。
5 导出.dmp格式的数据库语句:
exp scott/tiger@orcl
然后根据提示按回车直到备份结束成功!
6 恢复.dmp格式的sql语句
impusername
/
password
@orcl