这是用户创建的对象,由于IMP的时候先后循序的问题,导致状态变为invalid,
得自己从新编译,存储过程也会这样。
得自己从新编译,存储过程也会这样。
解决方案 »
- 虚拟机安装RAC,网卡可以用NAT方式连接吗?
- oracle10g的监听服务启动不了,报1067错误
- select into v1, into v2
- oracle8i的数据库恢复,在线等,请各位高手帮忙一下。
- 用Oracle存储过程,清空所有用户表数据?
- 在Oracle SQL *Plus 利用“Create type”创建新的数据类型不执行。
- 菜鸟问一个关于SQL*Plus登录的问题
- 郁闷了!大家给我推荐本将pro c的书吧(在线等)
- 两个表中的关联字段赋值问题
- oracle sqlplus 登录 用户名密码绝对正确,提示 监听程序当前无法识别连接描述符中请求的服务
- 哪有oracle7.3下载?
- 安装oracle8i for linux碰到个问题,大家帮我一下啊
in the following order:
1 New tables are created. A key point is that these are technically NEW tables
to the Oracle server. They have the same data and characteristics as the
original tables, but in reality they are being newly created in the database.
The reason that you cannot apply archive logs to roll forward an import is
that there is no synchronizing information stored in either the logs or the
export to specify when to start applying archived logs.
2 Index structures are built. The DBA can save some time during the import
process by setting the parameter INDEXES=N, then building the indexes
following the Import process. This will also limit the number of rollback
segments required to support the import.
3 Data is automatically imported in the tables because the parameter ROWS is
set to Y by default. Indexes are automatically populated because the
parameter INDEXES is set to Y by default. Indexes are created along with
the table and hence updated along with data import.
4 Triggers are imported and integrity constraints are enabled on new tables.The order in which you import tables may be important if you do not import all the
objects that a user owns. For, example, if the table with the foreign key has a
referential check on the table with the primary key, and the foreign key table is
imported first, then all rows that reference the primary key that have not been
imported will be rejected if the constraints were enabled. For a full database export this is not a problem.
llm06什么意思?english学的不好
有什么设置吗?