我在10g下导入文件报错,怎么回事呢?报错信息如下: C:\>imp smile/smile@orcl10g file="e:\dat\SMILE_20060109_01.DMP"Import: Release 10.1.0.2.0 - Production on 金 1月 20 09:40:17 2006Copyright (c) 1982, 2004, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc tion With the Partitioning, OLAP and Data Mining optionsExport file created by EXPORT:V10.01.00 via conventional pathWarning: the objects were exported by SMILET1, not by youimport done in JA16SJIS character set and AL16UTF16 NCHAR character set IMP-00031: Must specify FULL=Y or provide FROMUSER/TOUSER or TABLES arguments IMP-00000: Import terminated unsuccessfully
C:\>imp smile/smile@orcl10g file="e:\dat\SMILE_20060109_01.DMP"Import: Release 10.1.0.2.0 - Production on 金 1月 20 09:40:17 2006Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining optionsExport file created by EXPORT:V10.01.00 via conventional pathWarning: the objects were exported by SMILET1, not by youimport done in JA16SJIS character set and AL16UTF16 NCHAR character set
IMP-00031: Must specify FULL=Y or provide FROMUSER/TOUSER or TABLES arguments
IMP-00000: Import terminated unsuccessfully
//全库导入(出)为什么oracle10g里面没有管理数据库的工具呢?
//isqlplus(http://super:1581 好象是这个)
我之所以要这个管理界面是因为我用10g的Net Manager时:有一个连接的测试对吧!我要测试的!初始化首次测试请使用用户名: scott, 口令: tiger
正在尝试使用以下用户 ID 连接:scott
他提示说这个用户是过期的!expired!我进了管理界面了发现这个用户默认就是过期的!
我的问题如下:
1)为什么oracle10g和9i一样首次测试系统是用scott:tiger进行测试呢?
2)为什么我9i点测试就是好的,10g就说是过期的!