search for: table_owner

..._type, ''NUMBER'', data_scale, null) as scale from user_catalog cat, user_synonyms syn, all_tab_columns col where cat.table_name = ''USERS'' and syn.synonym_name (+)= cat.table_name and col.table_name = nvl(syn.table_name, cat.table_name) and col.owner = nvl(syn.table_owner, user) I am assuming that this is because development mode can''t cache the models... in production mode it seems to take about 8 seconds the first time but then it''s really fast. To test, I''ve placed this into SQLPlus and it takes about 6 seconds to execute there as wel...

...ice_year1_pkey PRIMARY KEY (ezone) ) WITHOUT OIDS; ALTER TABLE scen990.ezone_locationprice_year1 OWNER TO mscope; COMMENT ON TABLE scen990.ezone_locationprice_year1 IS 'calculated'; The RODBC function sqlTables() returns all the tables, but the records look like this: TABLE_QUALIFIER TABLE_OWNER TABLE_NAME TABLE_TYPE REMARKS mscope scen990 ezone_locationprice_year1 TABLE "" All the "REMARKS" values are empty strings. Can I get it to return the COMMENT ON values instead? (the table_owner and tablet_qualifier are switched but that doesn'...

Hi, after some experience with Rails on MySQL databases I gave it a try on one of our larger Oracle database. I was facing a problem when Rails tried to detect the columns for a model/table. The appropriate statement ran about 1 min which led to a timeout. Our Oracle guru told me to analyze the SYSTEM schema. After that hadn''t helped, he said the only remaining chance is to use a

...able with only the column headers. For example: > sqlQuery(con, "select * from PRICES.DB_PRICES") [1] COMMOD_CURVE START_DATE PRICING_DATE PRICE <0 rows> (or 0-length row.names) sqlTables also returns back an empty table: > sqlTables(con) [1] TABLE_QUALIFIER TABLE_OWNER TABLE_NAME TABLE_TYPE REMARKS <0 rows> (or 0-length row.names) And sqlFetch doesn't work either: > sqlFetch(con, "PRICES.DB_PRICES") Error in odbcTableExists(channel, sqtable) : 'PRICES.DB_PRICES': table not found on channel Are their other...

.... ##-------------------------------------------------------------------------------## > library(RODBC) > con <- odbcConnect("BIGSKY","***","**********") > con RODB Connection 0 Details: case=nochange 0?????????? > sqlTables(con) [1] TABLE_QUALIFIER TABLE_OWNER TABLE_NAME TABLE_TYPE [5] REMARKS <0 rows> (or 0-length row.names) > sqlQuery(con,"select * from Medium") [1] "[RODBC] ERROR: Could not SQLExecute" [2] "S1000 1 [unixODBC] Msg 2...

...FROM X.test"). However, I can't get the columns in table X.test with sqlColumns(db,"X.test") //it returns Error in sqlColumns(db, "X.test") : 'X.test': table not found on channel If I do sqlColumns(db, "test") it returns [1] TABLE_QUALIFIER TABLE_OWNER TABLE_NAME COLUMN_NAME DATA_TYPE [6] TYPE_NAME PRECISION LENGTH SCALE RADIX [11] NULLABLE REMARKS COLUMN_DEF SQL_DATA_TYPE SQL_DATETIME_SUB [16] CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLABLE DISPLAY_SIZE...

...;'NUMBER'', data_scale, null) as scale from user_catalog cat, user_synonyms syn, all_tab_columns col where cat.table_name = ''#{NAME_OF_TABLE}'' and syn.synonym_name (+)= cat.table_name and col.table_name = nvl(syn.table_name, cat.table_name) and col.owner = nvl(syn.table_owner, user) At first glance, the query looks okay. Oracle should apply the WHERE clause on the FROM tables and then apply the DECODE on the results. Unfortunately, that''s not the case. The decode is making the query very expensive. In my case, 10g running on Sun V880 server, with decode tak...

...case. (1, may be Davids comment already solves this?) There are still some problems with sqlTables() and sqlQuery() which should return a data.frame, but only return one line. I tried with MS Access and Oracle, and now odbcGetErrMsg() somewhat explains the problem. sqlTables(0) TABLE_QUALIFIER TABLE_OWNER TABLE_NAME TABLE_TYPE REMARKS 1 C:\\TEMP\\db NA MSysACEs SYSTEM TABLE NA Browse[1]> odbcGetErrMsg(channel) [1] "[RODBC]ERROR: Row count not supported" Why is this? If it is generally possible, that some ODBC drivers do not support Row count, then we need to check...

Greetings, I''m trying to put a Rails face on a Legacy Oracle 10 table. I am currently setting the table_name and primary_key, and I get the list and show to work fine. However, when I hit edit I just get the Editing <table name>, Edit button, Show, and Back. None of the fields are rendered. Why would I be able to show these fields in the show and list, but not edit them in the