Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a query layer directly running from ORACLE database in a MXD. I want to clip this layer with a layer being created in another MXD in a Python based tool. My question is to do this clip analysis, do I have to make a layer of this query layer locally or I can clip it directly from the query layer? I have success doing it with MakeFeatureLayer_management but then creating a layer of 6-7 million records every time this tool runs does not appear efficient and fails the whole purpose of creating query layer. SDE was never implemented for this project and setup was done before I joined the project. Alternatively I tried to run the model in query layer MXD but it will work stand alone and results in error with Python.

share|improve this question
also, adding a layer one time won't solve purpose. ORACLE data is continuously being changed by other applications. – Deep Sep 7 '12 at 20:14

Saving it as layer can resolve the issue since layer will take data from data source. so use this saved layer in the model. I need to do some rigorous testing since in my case an app is changing the data in source simultaneously to server side GP model run.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.