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: 未成功終止導(dǎo)入
連接服務(wù)器的操作自己通過sql developer連接
--連接到管理系統(tǒng)之后，下面是創(chuàng)建用戶
CREATE USER test IDENTIFIED BY 123456 DEFAULT TABLESPACE DBTraining TEMPORARY TABLESPACE DBTraining_TEMP;
--賦予一些權(quán)限
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導(dǎo)入表table1,table2
imp test/123456@ip/orcl:1521 file=E:\db.dmp tables=table1,table2
刪除用戶文章來源：http://www.zghlxwxcb.cn/news/detail-837368.html
drop user test CASCADE;
檢查test用戶的權(quán)限文章來源地址http://www.zghlxwxcb.cn/news/detail-837368.html
SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'test';
到了這里，關(guān)于【Oracle Database】如何遠(yuǎn)程連接服務(wù)器、創(chuàng)建用戶、從本地dmp導(dǎo)入表的文章就介紹完了。如果您還想了解更多內(nèi)容，請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
