Q

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.

This was first published in April 2005

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close