Oracle 问题集

1. 导入dump文件:

imp user/pass@ORCL full=y file=”文件位置.dmp” ignore=y

2. ora-01536:超出表空间“users”的空间限额:

alter user 你的用户名 quota unlimited on 你建表的表空间的名字;

3.修改IP后Oracle 无法使用

emca -config dbcontrol db

Advertisements

发表评论

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / 更改 )

Twitter picture

You are commenting using your Twitter account. Log Out / 更改 )

Facebook photo

You are commenting using your Facebook account. Log Out / 更改 )

Google+ photo

You are commenting using your Google+ account. Log Out / 更改 )

Connecting to %s

%d 博主赞过: