第一个问题: 先用sql plus登录到服务器上,执行一个建立用户的语句(oracle 8i): CREATE USER "PAWN" PROFILE "DEFAULT" IDENTIFIED BY "PAWN" DEFAULT TABLESPACE "SYSTEM" TEMPORARY TABLESPACE "SYSTEM" ACCOUNT UNLOCK; GRANT "EXP_FULL_DATABASE" TO "PAWN"; GRANT "IMP_FULL_DATABASE" TO "PAWN"; 用户建立后,再用DTS从sqlserver导入到oracle中
先用sql plus登录到服务器上,执行一个建立用户的语句(oracle 8i):
CREATE USER "PAWN" PROFILE "DEFAULT" IDENTIFIED BY "PAWN"
DEFAULT TABLESPACE "SYSTEM" TEMPORARY TABLESPACE "SYSTEM" ACCOUNT UNLOCK;
GRANT "EXP_FULL_DATABASE" TO "PAWN";
GRANT "IMP_FULL_DATABASE" TO "PAWN";
用户建立后,再用DTS从sqlserver导入到oracle中
是不是你操作不对?
指定为空的话直接把所有的表放在了system下,这样的话应用程序通过BDE可以访问吗?