How to solve Oracle error 959

Method: 1. Use "create tablespace...datafile 'dbf path' size 100M..." to create the table space; 2. Use "alter user demo quota unlimited on table space name" to specify the table space No restrictions are required.

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

How to solve oracle error 959

IMP-00003: 遇到 ORACLE 错误 959
ORA-00959: 表空间 'XXXXXXXXXXX' 不存在。

IMP-00017: Due to ORACLE error 959,

Solution:

1. Before importing , first create the table space

(The creation directory is the data directory of oracle)

create tablespace xxx datafile 'D:\oracle\data\xxx.dbf' size 100M autoextend on;

2. Specify the user and the table space is not restricted

alter user demo quota unlimited on xxx;//后面的xxx是表空间名

Then imp

Note that log must be specified when importing to facilitate analysis and solution

The example is as follows:

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of How to solve Oracle error 959. For more information, please follow other related articles on the PHP Chinese website!