I've looked at other posts (1)(2) around this error, but what I don't understand is where certain objects are located. I am unsure about where the tablespace (TEMP in my case) is exactly, and where the datafile that is added to it to extend its size would be located.

In several posts, I saw a file path for the datafile, but I don't understand where that's stored. To give some details, I am on macOS, and connecting to an Oracle database by using a bridge. Where would this datafile go in my case?

I've had a look at resources like this, but I am not the admin for the database I am using, and I am not sure what the equivalent tables are named in my database. How can I find out?

  • if you post here then please always add the exact error message.Contact an admin of the database and show the error message – miracle173 Oct 17 '17 at 6:36
  • 2
    select * from dba_data_files will show you the location of the tablespace files (on the database server) – a_horse_with_no_name Oct 17 '17 at 8:53
  • What do you mean by "connecting to an Oracle database by using a bridge"? You are on a computer (a Mac?) and the database is on another computer (of unknown OS?). The data file is stored on the server that runs the database. So an ora-1652 says "unable to extend a temp segment" in some tablespace. Not necessarily the TEMP ts. Hate to be "unhelpful" but if you are not the DBA ("but I am not the admin for the database I am using") then this really isn't your problem to solve. You need to be talking to the DBA who is responsible. – EdStevens Oct 18 '17 at 0:57
  • Thanks, EdStevens, I was just trying to gain a conceptual understanding of what was going on. I am not the DBA or admin, and I think it's more likely that the error is because "creating too many joins" as I've read in other places. – user136735 Oct 24 '17 at 20:23

Your Answer
