Forum Discussion

mkjit256's avatar
mkjit256
Advocate II
1 year ago
Solved

Oracle Datasource Error - ORA-01652: unable to extend temp segment by 128 in tablespace temp

Hello, I am connecting to two oracle DBs from the same pbix file. In power query, my first query has something as:   let Source = Oracle.Database("db1.world", [HierarchicalNavigation=true, Comma...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi mkjit256 

Based on the error message, Oracle hasn't enough space to store intermediate data , you may need to check the block size, you can refer to the following link.

sql - ORA-01652: unable to extend temp segment by 128 in tablespace SYSTEM: How to extend? - Stack Overflow

And you can refer to the following link abut monitor the sql statement.

ORACLE-BASE - Real-Time SQL Monitoring (DBMS_SQLTUNE.REPORT_SQL_MONITOR)

 

Best Regards!

Yolo Zhu

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

  • mkjit256's avatar
    mkjit256
    Advocate II
    1 year ago

    Thanks for your reply. i have one question, when i am loading the two oracle query to power query and then doing some transformations and then appending the two into one, shouldn't that be handled by the Power Query Engine. Not sure why after extraction, the data is being processed in Oracle again? did i misunderstand something?

    Thanks