19/01/2018 11:47
I have a tablespace comprised of 450 files.
I recently dropped a 400GB table from this tablespace. The table has27000 extents.
I'd now like to re-size each of the 450 files to its smallest possiblesize.
I'd like to have a script that can determine each file's smallestpossible size and generate the RESIZE syntax, which I will spool andrun.
Does anyone have a query that produces this required syntax?Thanks.
C

2 answersclick here to view

18/01/2018 11:47
I'm trying to use a query analyzer on some pre-existing procedure codeand can't get past this message.
Describe Error: Failed to execute EXPLAIN plan: ORA-00905: missingkeyword Here's the procedure. Below it are the tables.
/*************************************************************************** Deletes a row in the activities table by the primary key value.
Also cascade deletes all children and all other associated data.
*************************************************.... read more

1 answersclick here to view

17/01/2018 11:47
I've created a GLOBAL TEMPORARY TABLE where one of the columns stores the result of concatenating a variable (and unknown) number of VARCHAR2(100) cells. I didn't want to hit the 4,000 character limit when the source table has more than 40 rows so I created such temp column as CLOB. But when I joined my temporary table with some other regular tables I got an ORA-00932: inconsistent datatypes: expected - got CLOB error message. The problem seems to be that it's a SELECT DISTINCT query.... read more

5 answersclick here to view

16/01/2018 11:47
Dear all, when I try to install Oracle 9.2.0.4 to Redhat Enterprise AS3, the installerJVM program existed with the following error..
==========Error occurred during initialization of VMUnable to load native library: /tmp/OraInstall2004-04-17_08-12-10PM/jre/lib/i386/libjava.so: symbol__libc_wait, versionGLIBC_2.0 not defined in file libc.so.6 with link time reference========== I have ready get the following glibc filesets, do anyone know what filesetsam I still missing ??rpm -qa | grep glibglibc.... read more

1 answersclick here to view

15/01/2018 11:47
Hi, I have been searching for a LDAP solution replacing our Onames nameresolution today as 10g does not support Onames anymore.
I know that Oracle have OID as the LDAP solution, but I think it is aexpensive solution, just to have it for name resolution.
But if Oracle RDBMS is LDAP compliant, would it then be possible toinstall fx. an open source LDAP and use this as a solution ?? I have found one description on the web, that is should be possible,but the paper was not describing it in details .... read more

2 answersclick here to view

14/01/2018 11:47
Hi, I can successfully build a test form - it links to the database fine, so Ican create a single base table default form under scott/tiger.
It compiles succesfully. However, when I try to run I get: TNS-12560: TNS:protocol adapter error I have seen references to this error but with many causes, so I'm not surewhich configuration step I'm missing.
Perhaps if I describe what I did, the ommision may be obvious.
I'm working on a single stand-alone Windows XP pro machine running thelat.... read more

3 answersclick here to view

12/01/2018 11:47
Hello, I have a question about a query. I have a personnel table. In thistable there is a column for employee type (S_EType). I want to findthe average age of the group of employees by each employee type. Thereis no age column; only a birth date column. Therefore, some processingneeds to be done to determine age.
select s_etype, avg ( floor((sysdate - d_birthdate)/365.25) ) frompass.t_personnel group by s_etype This SQL isn't mathematically correct though. For example, let's sayth.... read more

5 answersclick here to view

11/01/2018 11:47
The situation: I currently have stored procedures that use global temp tables to holddiffering type of query criteria that is passed in to the procedure.
This enables me to easily do a join of these temp tables with variouspermanent tables to find data a user is interested in. However, I amrunning oracle 9.2 and am running into the unresolved bug in which ahuge amount of redo data is generated when inserting into temp tables.
This has caused havoc in our database with lots of other applications.... read more

5 answersclick here to view

10/01/2018 11:47
Hi, oracle version 8.1.5 - on some hpunix server.
The following procedure when executed, receives the error: SQL>execute testclob;call dbms_lob.writeBEGIN testclob; END; *ERROR at line 1: ORA-21560: argument 2 is null, invalid, or out of range PROCEDURE TESTCLOB AS f_clob clob; str varchar2(32767); b_int binary_integer;BEGIN b_int := 32767; str := 'See if I can write and read this to a temporary lob'; -- create temp lob and open in readwrite mode dbms_lob..... read more

1 answersclick here to view

04/01/2018 11:47
I have several database server, of cause is on different system withdifferent SID.
On client side, is it possible that I can set multiple TWO_TASK and howto set?Thus, I don't have to type into SID every time, only user name andpassword require.
Thanks.

5 answersclick here to view

03/01/2018 11:47
This topic has been extensively discussed here and elsewhere, withrespect to database connection. But what about compiling PL/SQL? We have a 9.2 database containing PL/SQL that needs to compile againsttables in a 7.x database. So we have created an 8i 'in between'database, which contains synonyms pointing to the 7.x tables.
Within the 9.2 database, it is possible using SQLPlus to select datafrom the 7.x tables (via database link to the 8i database). However itis *not* possible to comp.... read more

2 answersclick here to view

02/01/2018 11:47
Can anyone help. I have a requirement to gather stats in prod withoutthe values being put into the data dictionary and used immediately.
Instead I'd like them to go into a user stattab from where I can movethem into a non-prod instance.
That is, I'd like to do a gather_table_stats but specify the gatheredstats go to the stattab instead of a backup of the previous values.
Has anyone done this? Many thanks in advance.

6 answersclick here to view

01/01/2018 11:47
We have a ORACLE role with 50 different object privileges grant to it. Doesthere has way to generate a script which I can bring this script to anotherdatabase and re-create it? Thanks.

2 answersclick here to view

31/12/2017 11:47
Hi, Setting aside indexes, does anyone know how the technical Oracleinternals do row by row, field by field compares of data for a joinbetween 2 tables with decent performance ? Thanks, Jack

6 answersclick here to view

29/12/2017 11:47
Group, I was wondering how other people have their servers configured when there is more than one DBA working on the server/database.
For example things could be a lax as all DBAs can use the oracle unix account and login with a generic DBA account. Another option would be each admin has their own OS user id and is a member of the DBA group, but also has a Database account with DBA privs. ( which seems redudant because if you are a member of the DBA group you can always connect / as sysdba.
I.... read more

2 answersclick here to view

eDiscover
Helpforce eDiscover provides technical articles updated each day
Click the logo to go back to the main page
Databases

Helpforce eDiscover RSS feed contains the latest technical articles in RSSWe have a vast archive of technical informationA database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality in a way that supports processes requiring this information. This category deals with general databases and more specific vendor products such as MySQL and Oracle.

Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS