Tag Info

New answers tagged

1

Get the list of columns for a table in Oracle using ALL_TAB_COLUMNS from this query using ArcSDESQLExecute... select column_name from all_tab_columns where table_name = 'TABLE_NAME'. The returned list may need to be processed to eliminate unwanted columns.


0

It is the correct behaviour that the GFPTest user can't see the tables in SQL Developer, as the GFPTest user is not the owner of the tables. In order to see the tables in SQL Developer, in the Connections window in SQL Developer, expand the database connection (connected as the GFPTest user), expand the Other Users folder, expand the SDE user node, and ...


0

An Oracle geodatabase administrator should have training in Oracle database administration, not just rely on a few helper tools in the ArcGIS toolbox. Experienced Oracle DBAs create a number of tablespaces and roles before the first user, so letting the tablespace default in the tool is probably a mistake. Best practice in database administration calls ...


0

I'm not sure if this is your issue but I have run into problems in the past when trying to add Oracle tables from databases that do not have the SDE framework installed or a table that is not registered with SDE. You can try using the "Add Query Layer" option from "Add Data" in the file menu. The Add Query Layer tool is my first fallback option when I'm ...


1

1) Are the two databases running on similar hardware? 2) Have you tuned the Postgres server? By default Postgres is configured to run using minimal resources. That's good because you won't swamp your server just by setting it up, but it handicaps Postgres when you start to try to do real work. As a start here are two links to the Postgres Wiki to get ...



Top 50 recent answers are included