Search results for query: *

Hi, I'm having problems applying patchset 8.1.7.4. We are currently on version 8.1.7.2 and would like upgrade to version 9. However I'm told that to upgrade direct to version 9 you have to be on at least patchset 8.1.7.4, so the first thing I'm trying to do is move from from 8.1.7.2 to...

I would like to resize the temporary tablespace. It was increased in size to cope with the creation of a large index. However I would like to now recover the disk space by reducing it's size back to what it was. What I'd like to know is for a temporary tablespace do I need to resize it whilst...

Hi, I need some help with copying a schema (ie all objects owned by a particular user) from one database to another. What is the best way to do this?... I remember doing this a very long time ago, and I know when I did this then I had some problems then with constraint violations during the...

Hello Dima, Problem with the COPY command is how do I ensure that I am copying across all of the data in the long Raw column i.e that it's not being truncated. I am aware that you can set how much you want to copy, but what to set this to for a long raw column (to ensure I copy across...

Sorry, I made a mistake in my description of the problem. The copy is actually from Y to X ie "insert into X select * from Y where ..." etc, but I suspect you probably had already figured that out! Yakumo

I have a table with a LONG RAW column Y. I have created a copy of that table called X, when I try and copy records from X to Y via "insert into Y select * from X where ..." I get the following SQL error..."ORA-00997: illegal use of LONG datatype". Can anyone tell me how I can copy records...

Hi Alex, I looked on Metalink, there was a note I found (Doc ID 28814.1) on handling block corruptions. I tried everything in the note but no joy the table is still corrupt. I am trying an approach of creating a separate table and copying around the corrupt records. However the target table has...

We have two production datafiles that have block corruptions. DBVERIFY reports one oracle block corruption against each datafile. The two block_ids reported by dbverify belong to the same table TST03 (as checked in dba_extents). From our nightly backups we restored the two datafiles in...

I have a problem connecting to an Oracle ver 8.1.6 database on my laptop. Uptil about a week ago everything was fine, then I found I had a number of viruses on my laptop, so I installed the latest windows 2000 patches plus installed Firewall & Antivirus software and now I can't log onto the...

I have an Export dump file and would like to extract all of the DDL statements from it (ie create table, create index etc). Does anyone know if this is possible? Your help would be much appreciated. Regards Yakum

Thanks Dave (alias Mufasa), your response is both insightful plus sufficiently detailed for me to implement. I have just one problem. Our system is a SAP system and typically SAP systems have in access of 14000 tables!!! That is why I was hoping that I could use the spare machine in some way...

I would like to try something but need to check first if it is going to work. We urgently need to reorganize/defrag our production database server but cannot get sufficient down time. The Oracle version we are using is 8.1.7.4, running on HP-UX 11 unix operating system. However I had a...