Can anybody provide me an export and import script which I can use to export first a lot of BLOB-fields from a table to files and then reimport the files back to the table and the refering BLO...
How will I recover the following:
Oracle 9.2.0.5 database.
Backup steps..
1. Alter system switch logfile;
2. ALTER DATABASE BACKUP CONTROLFILE TO $ctrlbck'
3. All tablespaces but in...
Hello
Im used to sql servers and connections between tables and so on now i want to try how Oracle databases work.
But im having problem how to connect and insert data to oracle database...
Hi
i have a form was build on Oracle Form Builder 6i , and i have a procedure on the database , and i have a Database link...
now when i try to run that procedure on the SQL Plus ,,, it runs...
I am getting an error as 'JREW.EXE is stopping this installation' while installing ORACLE 9I on windows vista home edition operating system. Please give me a solution for the same.
I am trying to export a large blob into a sql command that I can execute later to another oracle database but i keep getting "String literal too long" when trying to execute the sql command.
...
Hi
I am facing one problem related to dbv utility and analyze command. Since long i am facing problem in my production database. so i decided to use dbv utility to verify if there is any bloc...
We received the following info from our DBA:
If PASSWORD_REUSE_MAX and PASSWORD_REUSE_TIME Used Together in 9i
--------------------------------------------------------------------------
...
We are currently running Oracle 9.2.0.1.0, but because I have a customer who is running 9.2.0.6.0, I need to upgrade to this version. My first question is what are the best practice steps to ...
I have a query which returns the values from a date column.
When the date is null the string value '--'- should be produce.
Unfortunately, I am unable to do it using the following formulas:...
Hi all,
How to find the maximum number of concurrent users that can be connected to a database at any point of time ?.
1) Since, for dedicated servers, UGA is part of PGA and UGA is the...
We are planning to add a new table with the following structure from SQL server to our ORACLE database. Its a history table of 10yrs of data, its rolling history table, always 10yrs of data w...
Hi, I have enabled auditing in an Oracle 9i instance, but the sys.aud$ table is still showing zero rows. I have set the value of audit_trail = TRUE. This has worked fine for me in other Ora...
Here's the script:
update t1
set t1.descr = t2.descr
from tax_juris_mstr t1
inner join taxjuris t2
on t1.juris_id = t2.juris_id
The 00933 error is referring to the 'from' line. Wh...
Hello,
For some reason I am not able to connect to database. I Keep getting this oracle error:
ORA-12154 tns:could not resolve the connect identifier specified
Nothing has changed.
TN...
I hit an import database error (imp-00000/00003) when i import oracle 9i unicode database in other machine with unicode Oracle 9i or 10g. After i check through the error list, i find out the...
During certain processes on my DB the disk I/O hits 100%, then the CPU is held in a WAIT state. No other processes can be run at the same time. I was using SORT_AREA_SIZE & SORT_RETAINED_SIZE ...
I am trying to create a Package that will encapsulate all the required parts to successfully call a Web service.
I already have the 'wsdl' HTTP site and it works 100% via a HTML call.
What...
How can I speed up deleting records from my Oracle db?
Currently I have multiple levels of FK constraints with cascade on delete, so when I delete the one record from the main parent table,...
Hi,
How identify and resolve fragmentation for
1. table spaces
2. tables
3. indexes
Thanks.
How to reorg the tablespace in oracle 9i
How can I restore the Orcale database from *.dbf files of Oracle. Other important files like redo log file and ctf file are missing. Give me the complete steps if any.
1.How to tune oracle sql query?
2. If database is hang, what is the step by step procedure?
3. Explain :- Full table scan?
Hi,
I'm looking to write an Oracle SQL query or procedure to bring back all table.columns in the schema where all rows for a given column are null. For example:
TABLE:
ID X Y ...
Hi in my form when we enter a record it check where the record exists or not ,
if exists it its gives an option to update. I have written a procedure for that and calling that procedure form ...
