Oraclethe Auxiliary tool V1.4 is divided into 64-bit and 32-bit, selected as needed. Enter the user name, password, and DB instance name to enter the gadget. 650) this.width=650; "id=" aimg_584 "src=" http://bbs.delit.cn/data/attachment/forum/201511/20/ 141554x4nln6lnw4889nid.png.thumb.jpg "width=" "height=" 280 "alt=" 141554x4nln6lnw4889nid.png.thumb.jpg "/>
1. Select the directory where the database table space is placed (the disk that holds the tablespace must have enough space to allocate as much space as possible), click Create table space;
2. Set the user name and password (recommended to use delit, to avoid forgetting later time), click Create User.
650) this.width=650; "id=" aimg_585 "src=" http://bbs.delit.cn/data/attachment/forum/201511/20/ 141557vk66bvkpkbndccqq.png.thumb.jpg "width=" 363 "height=" alt= "141557vk66bvkpkbndccqq.png.thumb.jpg"/>
3. Import the underlying packet, select the file in the import directory, and click Start Import. When the import is complete, the appropriate import log file is generated to see whether the import was successful or not.
650) this.width=650; "id=" aimg_586 "src=" http://bbs.delit.cn/data/attachment/forum/201511/20/ 141559zsiajjzmjaj2155a.png.thumb.jpg "width=" 363 "height=" alt= "141559zsiajjzmjaj2155a.png.thumb.jpg"/>
4. Modify the Oracle password to never expire.
Because "password_life_time=180 days" is set by default in oracle11g in the defaults profile. So we have to change the Oracle Password never expires, otherwise it will cause client login error.
650) this.width=650; "id=" aimg_587 "src=" http://bbs.delit.cn/data/attachment/forum/201511/20/ 141602a68a584y913nnss8.png.thumb.jpg "width=" 363 "height=" alt= "141602a68a584y913nnss8.png.thumb.jpg"/>
Original address: http://bbs.delit.cn/thread-335-1-1.html
Reprint please specify the source:
Author: metric Technology http://www.delit.cn
Description of the Platform database Import and Export shortcut tool