After this I created a user (create user "mapdata" identified by mapdata default tablespace GIS data temporary tablespace temp) and then granted connect and resource roles to my user (mapdata).
I started adding/creating some objects into the mapdata user. The problem is that the data is being added into another data file rather than the one I mentioned in my tablespace, the one I created for my user mapdata.
Can you please explain why the data is being added into a different data file?
GIS data is typically loaded into the RDBMS using specific tools. You did not mention which GIS tools you are using to handle your spatial data. You'll have to look at the tools to verify how the tables are being created and allocated. For instance, if you are using ESRI's ArcSDE, then you need to specify a keyword when loading the data. This keyword tells ArcSDE which tablespace to create the tables and indexes in. If you do not supply a keyword, the DEFAULTS keyword is used, which could very well point to a different tablespace than you intended. In this case, the user's default tablespace is never even consulted.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.