Problem solve Get help with specific problems with your technologies, process and projects.

Data being added to the wrong data file

I created a tablespace (e.g., a GIS data logging data file called "C:dataoracledatagisdata.dat") with a size of 500m, with reuse and autoextend on the next 100m.

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?

I'm assuming that "GIS data" is Geographical Information Systems data, or spatial data, a subject that I work with on a daily basis! I further make this assumption since the user is called "mapdata."

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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.