The local server does not have the Orcale database and client installed, and Plsql is not installed. Therefore the imp command of CMD cannot be used.
Install the Orcale client locally, install, configure path, and then import the DMP file with the IMP command after installation.
Install Instantclient_11_2, and unzip OK;
Install Plsql,, unzip the direct punch card Plsqldev.exe, the interface is English, can be changed to Chinese. Configure the Orcale path and OCI path.
Import
Search API that delivers instant and relevant results from the first keystrokeReact:online tesinghttps://jsfiddle.net/reactjs/69z2wepo/XxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxXxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxXxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxCDN accelerates
The local server does not have the Orcale database and client installed, and Plsql is not installed. Therefore the imp command of CMD cannot be used.
Install the Orcale client locally, install, configure path, and then import the DMP file with the IMP command after installation.
Install Instantclient_11_2, and unzip OK;
Install Plsql,, unzip the direct punch card Plsqldev.exe, the interface is English, can be changed to Chinese. Configure the Orcale path and OCI path.
Import
/1024 from dual;
65673*8/1024------------513.070313
--The actual physical space occupied is 513MB multipoint
4. The final step is to modify the size of our data file to be larger than the physical space actually occupied by this tablespace:
sql> ALTER DATABASE DataFile ' D:\oracle\product\10.2.0\oradata\orcl\USERS01. DBF ' Resize 600m;
The database has changed.
OK, the data file changed from 1.4GB before the change to 600MB. For other data
To view disk space usage:Df-hView the space occupied by the first level directory under the root directory:Du-h--max-depth=1/Find files larger than 2000M in the root directory:Find/-size +2000mFind files that have been deleted, but are still occupied by the process:Lsof |grep deletedReview the process information based on the process ID found in the previous step:Ps-ef | grep pidServices to restart the proc
Baidu Personal Cloud disk space large, completely free, but also provides a PCs API to invoke the operation of files, in peacetime projects in the inside to save some files is very practical.
Environment Preparation:
Access to read and write network disk and access to access_token:http://blog.csdn.net/langyuezhang/article/details/47206621
Baidu official PCs AP
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.