Subject:RE: Urgent: Retrieving Disk Space
Why don't you try to 'alter table move' the table to the tablespace it
should be in. If no other objects are beyond the block of the block 0 of the
segment, you should be able to resize the system01.dbf file. If something
else got created and is owned
:23 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Urgent: Retrieving Disk Space
Why don't you try to 'alter table move' the table to the tablespace it
should be in. If no other objects are beyond the block of the block 0 of the
segment, you should be able to resize the system01
Hi
What has grown?
you don't mention datafiles. So if there is only the three types of files
you mention there I can only assume that the part that has grown is the
number of archive logs. These are needed for recovery since last backup and
can not be thrown away. can be zipped though.
If
All the files you mention here are critical files.
What is the Temp File Size. Did u see that. Why did the table not get
created.
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
Live to
Thanx Jack,
The size of System01.dbf has grown from 1GB to 4GB
The size of temp01.dbf is around 1GB now.
Best Regards,
Aleem
-Original Message-
Sent: Tuesday, June 04, 2002 1:18 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Urgent: Retrieving Disk Space
Hi
Aleem,
Did you mention control files, redo log files, archive log files with
recovery in mind?
If so, you probably don't need it.
Read next if you have all the files for the database on this one poor hard
drive:
Review the cause for create table as select... command. If it is the
message like
that the SYSTEM01.dbf does indeed belong to the
SYSTEM tablespace. !!!
--
From: Abdul Aleem[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Tuesday, June 04, 2002 4:03 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Urgent: Retrieving Disk Space
: Tuesday, June 04, 2002 1:18 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Urgent: Retrieving Disk Space
Hi
What has grown?
you don't mention datafiles. So if there is only the three types of files
you mention there I can only assume that the part that has grown is the
number
: Urgent: Retrieving Disk Space
All the files you mention here are critical files.
What is the Temp File Size. Did u see that. Why did the table not get
created.
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
, June 04, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Urgent: Retrieving Disk Space
Aleem,
Did you mention control files, redo log files, archive log files with
recovery in mind?
If so, you probably don't need it.
Read next if you have all the files
last nearly 1GB
Aleem
-Original Message-
Sent: Tuesday, June 04, 2002 1:53 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Urgent: Retrieving Disk Space
All the files you mention here are critical files.
What is the Temp File Size. Did u see that. Why did
To: Multiple recipients of list ORACLE-L
Subject:RE: Urgent: Retrieving Disk Space
Hi,
Autoextend is on for system tablespace (why?).
What's the default tablespace for the account the developer used to create
the object (system?), if not system his objects should not go to system
tablespace so
!
Aleem
-Original Message-
Sent: Tuesday, June 04, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Urgent: Retrieving Disk Space
Aleem,
Did you mention control files, redo log files, archive log files with
recovery in mind?
If so, you probably don't need it.
Read
files there, which is probaly your case.
--
Alexandre
The size of temp01.dbf is around 1GB now.
Best Regards,
Aleem
-Original Message-
Sent: Tuesday, June 04, 2002 1:18 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Urgent: Retrieving Disk Space
Hi
What has grown
14 matches
Mail list logo