Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
JenniferLin
Frequent Visitor

Oracle Import Error

I have been trying to import a dataset from Oracle.

However, I kept getting the following error

 

 

Annotation 2019-12-02 131745.png

 

Could anyone please help advise the solution to this error.

Any help is greatly appreciated, thanks

1 ACCEPTED SOLUTION
V-lianl-msft
Community Support
Community Support

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

View solution in original post

2 REPLIES 2
V-lianl-msft
Community Support
Community Support

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
Community Support
Community Support

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.