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?

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: