Login -> SYSDBA
Trying to export 2 tables from HR schema using the following command:
C:\>expdp directory=dpump_dir1 Tables=REGIONS, LOCATIONS dumpfile=HR.dmp logfile=HR_2tbls.log
Receivin...
How can I change the below "Test #2"
to display all 2,579 records,
including the "fmen.FMTEXT"
column if it exists ?
** small Oracle table sample attached
--------------------------...
I am having an issue with Oracle 9i Enterprise Edition 9.2.0.3.0 running on Windows that Oracle will spawn a new process (thread) every hour at exactly the same time. In effect, my database i...
Hi experts, i need a simple script (e.g. a bat file) (to be executed by a simple user) just to check if an oracle database is up and running and by the same token to check if the drives are ac...
Can anyone advise-How can i retreive the output of following test sql file and used in bash script further. I am using following sqlplus line in bash script. i want the cnt value to be passed ...
I'm having a problem with SYSDATE not returning the correct value. I'm running Oracle 9i on an IBM RS/6000 running AIX 5.2. I'm pretty sure the problem relates to how AIX/Oracle are handling t...
could not find oracle home for toad when i open it..., how to set oracle home?
I have a export dumpfile in my c drive which I transferd from ftp site
now I need to import it to my schema cust .
can some one give me the syntax?
win2003
" You are performing more than 874 disk reads per second. High disk latency can be caused by too-few physical disk spindles. Compare your read times across multiple datafiles to see which data...
How to setup RMAN Backup on windows both with Catalog and without Catalog on Oracle 10g
Doing the below causes
alot of trailing "white space".
How can I trim
"TO_CHAR(fmen.FMTEXT)" ?
SELECT fmf.FMCODE, fmf.FMVERSION, TO_CHAR(fmen.FMTEXT)
FROM FMFORMULA fmf
LEFT JOIN FM...
Hi, the code below gives the error : 'ORA-00907: missing right parenthesis'. I couldn't see where the problem is.
Thanks in advance...
Need a query or procedure that if its before noon return yesterday's date else
return today's date
I have several materialized views that I wish to refresh on schedule with a refresh group. I can successfully do a complete refresh individually with the syntax:
CREATE MATERIALIZED VIEW my_m...
I want to upgrade my v9.2 database to v11g with minimal downtime, and I'm considering two options:
* Oracle Streams
* Quest Shareplex
I can't afford the downtime to do an export/import ...
Hi all,
I have a table in oracle, have a certain field called end_date .. now I don't know what is the format or that end_date field, is it timestamp or a date or whatever .. this is proble...
I want to upgrade Apex 2.1 on Oracle 10g on windows 7. But, I couldn't find an easy to do solution or document on web. Any advice for upgrade ? Thanks in advance.
Hi I have an oracle table that holds the time in a number datatype like '17.1000004' which will translate into something around 17:06 or 09.7500001 would be 9:45
i need to do this in a sele...
Can someone explain jow to execute an Analyze and view results in 10g for a materialized view?
Thanks!
Hi All,
I'm using a cursor with a bulk collect to determine all records which must be updated based on a corresponding field in a table of the same properties.
so snippet looks like this...
Can somebody re-write this query to save CPU time.
Right now it is titanic. like replacing the right outer join with left etc...
Please suggest a solution to the following problem. The last backup for the file is on September 6th.
Should I issue blockrecover datafile 39 block 1345537';
Hi all,
How can I remove empty oracle home without OUI?
Thanks
Regards
Bibi
how to change the temp tablespace size?
I did use
alter database datafile ' ' resize 400m;
?
Hi
I have Unix server(master) has Oracle10g database ,
we bring a new windows server(slave) with Oracle10g version too,
and does not has any database structure or data.
The final aim i...
