Oracle Import Error

[JenniferLin]

I have been trying to import a dataset from Oracle.

However, I kept getting the following error

Could anyone please help advise the solution to this error.

Any help is greatly appreciated, thanks

[V-lianl-msft]

Hi @JenniferLin ,

Is this problem sloved?
If not, please let me know.

Best Regards,

Liang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[V-lianl-msft · Accepted solution]

Hi @JenniferLin ,

The reason for this is failed to allocate an extension of the required number of blocks for a temporary segment in the tablespace indicated, you could try to add one or more files to the tablespace indicated.

You can refer to this, and you need to know the implications of using directquery .

(Note: This link contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.)

Best Regards,

Liang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly