Search results for query: *

thanks for that. the details i gave were just very skimpy. i really want to know the maths involved/the method for working something similar out. also the term copy was wrong we were builing context search indexes. like i say it was just for the mathematical method involved. Many Thanks...

If it takes 63150secs on a computer of power 496MHz to copy 1626826 records. How long will it take on a computer of 1600Mhz to copy the same number of records? can someone show me some working so I can work it out myself next time. Many Thanks. Thiko!

I have this pl-sql procedure to work out the median value of a set of id numbers from a table. It created with no errors but when i execute in sqlplus i get: SQL> execute median_value; begin median_value; end; * ERROR at line 1: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of...

We use Spotlight for Oracle on our production databse and used the SYS user and password for first connection to set up the Spotlight user and objects etc. Many Thanks. Thiko!

How does one work out the DB Server RAM GB's Size, the IO Cache RAM GB's Size, the RAID Level and the SMP / MPP # CPU's for ones database? Many Thanks. Thiko!

thanks!! Many Thanks. Thiko!

can someone tell me where to remove the quotes on this select to remove the last quote from the result??? I just can't see it! SELECT 'host exp80 '||var1||'/'||var2||'@ora.comp789 FILE=exp_'||var1||'_'||TO_CHAR(sysdate,'dd-mm-yyyy_HH24:MI:SS')||'_seq'||ExportDumpID.NEXTVAL ||'.dmp GRANTS=Y...

I would like to after running the below from a pl-sql block run the line that is produced... Any ideas how to do this? set serveroutput on Server Output ON declare runexport VARCHAR2(200); begin SELECT 'host ''exp FILE=exp_'...

Hi I'm getting a bit confused (surprise surprise). I have this pl-sql block where if function dba_services.permissions = 0 then it will set status to failed in the jobrequest table, but if it is not = to 0 i would like it to go onto the next step in the application - Which is to do an export...

Hi, i got this off metalink for you: Problem Description ------------------- You are attempting a client connection to an 8i database via sqlplus and receive the following errors: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error...

it will be NT (although the server is unix.) please could you give me a clue on how it can be done on NT. Many Thanks. Thiko!

can one host out of a pl-sql block? e.g. DECLARE .... BEGIN .... IF .... > 0 THEN host run exportscriptfile; END IF; COMMIT; END; Many Thanks. Thiko!

I have this function and I would like to call it in a pl-sql block in a script to see if the userid is in the permissions table, which is what the function does. How do I call this procedure in a pl-sql block? CREATE OR REPLACE PACKAGE BODY dba_services AS FUNCTION permissions (current_user...

I would like to pass in the users schema name and the date of the export and the sequenceid from a database sequence called ExportDumpID for the name given to the export dump file. So far I have the date and sequence passed into the filename using sqlplus scripting. Then I have a pl-sql...

I would like to pass in the users schema name and the date of the export and the sequenceid from a database sequence called ExportDumpID for the name given to the export dump file. Any ideas how to put this into the filename for the export dump file? e.g. betty_08JUN2001_45.dmp Many Thanks...

Is it possible to get the version number of a script run into the database so it can be read from the database. May be v$version? Many Thanks. Thiko!

Which Data Dictionary will tell you whether there are any unique indexes created in your database? Created with a Create Unique index..... not an alter table add primary key statement..... Many Thanks. Thiko!

When doing an alter table statement to add a foreign key is it possible to specify which tablespace you want the index to go into? ALTER TABLE mediaitemrep ADD CONSTRAINT mediaitemrep_mediaitem_fk FOREIGN KEY (mediaitemid) REFERENCES mediaitem(mediaitemid) / Many Thanks. Thiko!

Hi what does DBSNMP stand for? Many Thanks. Thiko!

syntax error..........: alter tablespace <tablespace_name> add datafile '/data/oracle/mount3/<tablespace_name>' size 100M autoextend on next 10 maxsize 1500M ; Many Thanks. Thiko!