C:\Users\test>imp test/123456@ip/orcl:1521 file=E:\db.dmp tables=table1,table2
Import: Release 11.2.0.3.0 - Production on 星期一 3月 4 12:59:09 2024
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
IMP-00058: 遇到 ORACLE 错误 12638
ORA-12638: 身份证明检索失败
IMP-00000: 未成功终止导入
连接服务器的操作自己通过sql developer连接
--连接到管理系统之后，下面是创建用户
CREATE USER test IDENTIFIED BY 123456 DEFAULT TABLESPACE DBTraining TEMPORARY TABLESPACE DBTraining_TEMP;
--赋予一些权限
GRANT CREATE TABLE TO test;
GRANT CREATE VIEW TO test;
GRANT CREATE MATERIALIZED VIEW to test;
GRANT CREATE SEQUENCE TO test;
GRANT ALTER ROLLBACK SEGMENT TO test;
GRANT CONNECT,RESOURCE TO test;
ALTER USER testQUOTA UNLIMITED ON DBTraining;
grant DBA,IMP_FULL_DATABASE to test;
--从本地E:\db.dmp导入表table1,table2
imp test/123456@ip/orcl:1521 file=E:\db.dmp tables=table1,table2
删除用户文章来源：https://www.toymoban.com/news/detail-837368.html
drop user test CASCADE;
检查test用户的权限文章来源地址https://www.toymoban.com/news/detail-837368.html
SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'test';
到了这里，关于【Oracle Database】如何远程连接服务器、创建用户、从本地dmp导入表的文章就介绍完了。如果您还想了解更多内容，请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章，希望大家以后多多支持TOY模板网！
