Latest Contributions by WilliamCraft

Exporting from one does not imply that you would or should get records from the other.  Just because they're related via relationship class doesn't mean anything when you're talking about exporting selected records.  The exports for selected records have to be done separately no matter how you make your selection.  So, exporting feature class records to a new feature class would not mean that you could automatically get the related records from the table... and vice versa.  It's just the way the software is designed.  The fact that the relationship class is set up as 1-M (one to many) has nothing to do with this.  The only exception to this rule is in the case of a Copy/Paste from within ArcCatalog... but in that case you're dealing with the entire recordsets rather than a selection set from each. ... View more

I don't want to use oracle libraries any more because of oracle 32 /64 bit issues in 10.2. Just curious, what 32/64 bit issues are you referring to with 10.2? ... View more

but its not allowing me to export data from both. If I do as you suggested, I can only export from one table. I'm not sure that I understand the problem you're having.  The selected records from the feature class can also be exported in the same fashion as described with the related table.  So, you query the feature class, then export the selected features into a new feature class, then walk through the steps I described above in order to produce the new table from the selected related records. ... View more

You can't.  That's the drive letter that Windows is defaulting to.  This is the case for anyone who opens a CMD prompt.  Refer to my two suggested commands above.  One has double quotes and the other does not.  If your ArcGIS for Server installation was on the "U" drive, then change the text I provided such that the C:\ portion is changed to U:\ instead.  If your installation is on the "C" drive, then use the text exactly as I provided above.  If you're still having trouble, please take a screenshot of the Computer dialog box from your Windows OS.  Here is my example: [ATTACH=CONFIG]33532[/ATTACH] ... View more

If you require elevated privileges to run an Administrator CMD, then you likely aren't an admin on that machine as you pointed out.  So, yes, you might need an admin to do this.  However, looking at your screenshot I don't believe you're issuing the correct command to begin with.  Try opening up a CMD prompt and input this: C:\Program Files\ArcGIS\Server\tools\passwordreset\PasswordReset.bat or "C:\Program Files\ArcGIS\Server\tools\passwordreset\PasswordReset.bat" Post back with your results.  Resetting the PSA account password should not break applications or services.  Just to be clear, can you confirm that your ArcGIS for Server installation directory exists on the "C" drive and not the "U" drive? ... View more

Users who are outside of the LAN could connect to SDE if they had VPN access.  There are likely other ways of getting users at remote sites connected to your instance of SDE if they are not already part of your wide area network (WAN).  I would not offer access to SDE publicly over the internet, though. ... View more

Have you granted permissions to the SDE user and to PUBLIC on the database into which you imported? grant CREATE SESSION to sde; grant CREATE VIEW to sde; grant CREATE ANY INDEX to sde; grant CREATE TABLE to sde; grant CREATE TRIGGER to sde; grant CREATE PROCEDURE to sde; grant CREATE SEQUENCE to sde; grant CREATE INDEXTYPE to sde; grant CREATE LIBRARY to sde; grant CREATE PUBLIC SYNONYM to sde; grant CREATE OPERATOR to sde; grant DROP PUBLIC SYNONYM to sde; grant ADMINISTER DATABASE TRIGGER to sde; GRANT EXECUTE ON dbms_pipe TO public; GRANT EXECUTE ON dbms_lock TO public; GRANT EXECUTE ON dbms_lob TO public; GRANT EXECUTE ON dbms_utility TO public; GRANT EXECUTE ON dbms_sql TO public; GRANT EXECUTE ON utl_raw TO public; After that, you may need to recompile these: alter package sde.pinfo_util compile; alter package sde.lock_util compile; alter package sde.version_user_ddl compile; ... View more

We use IMP and EXP often to refresh the SDE schema and other user schemas for our 11g test databases.  I think you have the syntax right, and it looks like you were able to export and import fine.  The error looks to occur in ArcGIS Desktop.  I would first suggest that you try recompiling any invalid objects then try again to connect.  Run this in SQLplus as SYS user: EXEC DBMS_UTILITY.compile_schema(schema => 'SDE'); Post back with your results. ... View more

Are you asking if it's possible to have records from the related table be selected automatically based on what you select in the feature class, and then export the selected records from the related table to a new table?  If so, then the answer is 'yes'.  Issue a selection against your feature class in ArcMap, either using Select By Location, Select By Attribute, or manually selecting whatever records you need through the attribute table or the map.  Once you've made your selection against your feature class, open the attribute table and click the Related Tables button.  That is the button with two little green tables and two arrows; it's at the top left of the feature class attribute table.  The related table is displayed with the related records selected.  Once the selected records appear for the related table, you can export only the selected records to create your new table either from the attribute table (top left drop-down button at the top) or from the Table of Contents (right click the table).  These steps assume you have a relationship class set up between your feature class and your related table as you described earlier.  Does this answer your question?  If so, please mark the correct answer with the green check. Here is the help section on accessing related records.  I'm assuming 10.2 at the moment. ... View more

So what I'm gathering here is that you exported an XML workspace with data from GDB 3, imported that XML workspace into GDB 1 and into GDB 2, then used the Register as Existing Replica option via the distributed geodatabase toolbar in ArcMap.  Is that right?  If so, when you did the replica registration, what did you register each GDB with? ... View more

Client computer has been restarted. The feature dataset, a feature class, and several tables are part of a replica between default on this geodatabase and a version on another geodatabase. Is this a one-way or two-way replica?  If one-way, I assume your are attempting to edit data in the parent replica and NOT the child.  If two-way, have all edits been synchronized and subsequently acknowledged between the two replicas? ... View more

Thanks for clarifying, George.  That is helpful.  I'm curious to hear if this help's Matt's performance issues as described above. ... View more