Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Oracle DB Error: ORA-01555

I am importing data from Orcle BD using ODBC connecor. I didn't have any problem importing data from the same table before but now running into issues. The data is fairly large, more than million row...
Need Help
  • dramus's avatar
    dramus
    8 years ago

    That error is coming from the oracle database.

     

    It is an issue with the length of time that your transaction has been open. Oracle is trying to preserve the read context (What the database looked like when you started the query), but the data it needs has aged out of the UNDO Tablespace.

     

    You have two options:

     

    1. Tune your query so that the data is returned quicker.
    2. Talk to your DBA about increasing the size of the UNDO tablespace.

     

    http://www.orafaq.com/wiki/ORA-01555

dramus's avatar
dramus
Icon for Continued Contributor rankContinued Contributor
8 years ago

That error is coming from the oracle database.

 

It is an issue with the length of time that your transaction has been open. Oracle is trying to preserve the read context (What the database looked like when you started the query), but the data it needs has aged out of the UNDO Tablespace.

 

You have two options:

 

  1. Tune your query so that the data is returned quicker.
  2. Talk to your DBA about increasing the size of the UNDO tablespace.

 

http://www.orafaq.com/wiki/ORA-01555

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks.. I will reduce the Query size and try it over the weekend. Hopefully, it will work. 

 

Is there a limit in Power BI on query time and table size? 

 

Thanks