Search results for query: *

The table structure for the Oracle database, not the mainframe. The product is Enterprise EV2. Yes, they are hosted, but they are migrating off, and we already have an Oracle backup. I need to see the table structure, what links to what, etc. to pull data via SQL. A graphical physical...

Does anyone have a data map/chart or schema of all the ADP (Automatic Data Processng) tables and how they link by field? This is for the hosted Oracle web version they now offer. I know Ceridian provides such a chart. My client is about to end their contract with ADP, so they are not getting...

Hi, RSHelp! True, you CAN also link in MS SQL in the WHERE clause as in Oracle, but for very advanced joins, you must do it in the FROM (you are very limited in the WHERE on linking with MS SQL). As a result, I am accustomed to doing all my MS SQL linking in the FROM clause. I forgot that the...

Thanks. Also, what Oracle user should I be using to create a tablespace? I tried to make one using the "system" user to give it the one it wanted, but it seemed like the tablespace didn't get created. I used the GUI screens to do it. Also, how do you know what size to make it?

Thanks. Also, what Oracle user should I be using to create a tablespace? I tried to make one using the "system" user to give it the one it wanted, but it seemed like the tablespace didn't get created. I used the GUI screens to do it. Also, how do you know what size to make it?

I'm importing a dmp file from another Oracle database into Oracle 10g. I'm using the command line with "full=y" to do it, but I get many errors about table spaces and users not existing. I have tried turning off grants, no luck. I tried the GUI way as well, other problems. It reads the import...

When attempting to link tables in the ADP company level jobcode table to the employee job table via jobcode by "edit(ing) the SQL" query in the report. When we added our linking to the from clause of the query, as you can do in true SQL (client and I are SQL people, not Oracle), it failed with...

What I ran into is that when I exported the data to Excel, there seemed to be a very low record number limit that you could export. I believe it was less than about 10,000 rows. The way we were getting to Excel was with a file, save as after the report had run. Perhaps this was not the...