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 last published in April 2005

Dig Deeper on Oracle database backup and recovery

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close