Search results for query: *

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...

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!

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...

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!

can someone please tell me whats wrong with this? after getting an ORA-01658: unable to create INITIAL extent for segment in tablespace <tablespace_name> i decided to try to add another datafile to the tablespace to add additional space. alter tablespace <tablespace_name> add datafile...

as well as copying all datafiles across from the primary database to the standy by, should you also copy the rollback segments? Many Thanks. Thiko!

We have some oracle datafiles *.ORA of a considerable size and they need to be sent by ftp accross the network to the standby database machine. Is it save to zip up these datafiles and unzip them on the other side? At the momemnt at their current size they are taking too long to ftp..... Many...

Hi R CPU's for a Sun E4500 hot swapable? We want to add some more... Many Thanks. Thiko!

i would like to find out the size that some database datafiles were created at in megabytes. so if i select bytes from dba_data_files could someone tell me the syntax for convering the size information into megabytes? Many Thanks. Thiko!

is it possible to extract the create database statement that was used to create a database? i would like to use/amend a copy from another machine for a new database.... Many Thanks. Thiko!