Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Tablespace numbering

Tablespace numbering

From: Dino Hsu <dino1_nospam_at_ms1.hinet.net>
Date: Mon, 23 Jul 2001 15:53:53 +0800
Message-ID: <jnlnlto6kfuomlu5h83ffn7o86hlo9debv@4ax.com> 






Dear all,



Cognos Transformer encounters an Oracle error when creating the cube
as follows:



<Transformer log begin>




PowerPlay Transformer(6.5.283.0 )  Mon Jul 23 15:45:29 2001



LogFileDirectory=d:\dm_work\dm_log


ModelSaveDirectory=d:\dm_src\dm_model


DataSourceDirectory=d:\dm_work\dm_dat


CubeSaveDirectory=d:\dm_work\dm_cube


DataWorkDirectory=d:\dm_work\dm_temp


ModelWorkDirectory=d:\dm_work\dm_temp


MaxTransactionNum=5000000


ReadCacheSize=4096


WriteCacheSize=16384



PowerPlay Transformer  Mon Jul 23 15:45:30 2001
PowerPlay Transformer(6.5.283.0 )  Mon Jul 23 15:45:30 2001



LogFileDirectory=d:\dm_work\dm_log


ModelSaveDirectory=d:\dm_src\dm_model


DataSourceDirectory=d:\dm_work\dm_dat


CubeSaveDirectory=d:\dm_work\dm_cube


DataWorkDirectory=d:\dm_work\dm_temp


ModelWorkDirectory=d:\dm_work\dm_temp


MaxTransactionNum=5000000


ReadCacheSize=4096


WriteCacheSize=16384


2001/07/23 PM 03:45:45	4	00001B81	Start cube update.
2001/07/23 PM 03:45:45	4	00001B81	Initializing
categories.
2001/07/23 PM 03:45:45	4	00001B81	Timing, INITIALIZING
CATEGORIES,00:00:00
2001/07/23 PM 03:45:45	4	00001B81	Start processing data
source '\dm_src\dm_model\products.iqd'.
2001/07/23 PM 03:45:45	4	00001B81	Reading source data.


PowerPlay Transformer DA Server(6.5.283.0 )  Mon Jul 23 15:45:46 2001



PowerPlay Transformer DA Server  Mon Jul 23 15:45:49 2001
2001/07/23 PM 03:45:49	4	00001B81	End processing 6538
records from data source '\dm_src\dm_model\products.iqd'.
2001/07/23 PM 03:45:49	4	00001B81	Timing, READ DATA
SOURCE,00:00:04



2001/07/23 PM 03:45:49	4	00001B81	Marking categories
used.


2001/07/23 PM 03:45:49	4	00001B81	Timing, MARKING
CATEGORIES USED,00:00:00



2001/07/23 PM 03:45:49	4	00001B81	Initializing
categories.

2001/07/23 PM 03:45:49	4	00001B81	Timing, INITIALIZING
CATEGORIES,00:00:00
2001/07/23 PM 03:45:49	4	00001B81	Start processing data
source '\dm_src\dm_model\offers.iqd'.
2001/07/23 PM 03:45:49	4	00001B81	Reading source data.


PowerPlay Transformer DA Server(6.5.283.0 )  Mon Jul 23 15:45:50 2001



PowerPlay Transformer DA Server  Mon Jul 23 15:45:52 2001
2001/07/23 PM 03:45:52	4	00001B81	End processing 67
records from data source '\dm_src\dm_model\offers.iqd'.
2001/07/23 PM 03:45:52	4	00001B81	Timing, READ DATA
SOURCE,00:00:03



2001/07/23 PM 03:45:52	4	00001B81	Marking categories
used.


2001/07/23 PM 03:45:52	4	00001B81	Timing, MARKING
CATEGORIES USED,00:00:00



2001/07/23 PM 03:45:52	4	00001B81	Initializing
categories.

2001/07/23 PM 03:45:52	4	00001B81	Timing, INITIALIZING
CATEGORIES,00:00:00
2001/07/23 PM 03:45:52	4	00001B81	Start processing data
source '\dm_src\dm_model\occp.iqd'.
2001/07/23 PM 03:45:52	4	00001B81	Reading source data.


PowerPlay Transformer DA Server(6.5.283.0 )  Mon Jul 23 15:45:53 2001



PowerPlay Transformer DA Server  Mon Jul 23 15:45:54 2001
2001/07/23 PM 03:45:54	4	00001B81	End processing 13
records from data source '\dm_src\dm_model\occp.iqd'.
2001/07/23 PM 03:45:54	4	00001B81	Timing, READ DATA
SOURCE,00:00:02



2001/07/23 PM 03:45:54	4	00001B81	Marking categories
used.


2001/07/23 PM 03:45:54	4	00001B81	Timing, MARKING
CATEGORIES USED,00:00:00



2001/07/23 PM 03:45:54	4	00001B81	Initializing
categories.

2001/07/23 PM 03:45:54	4	00001B81	Timing, INITIALIZING
CATEGORIES,00:00:00
2001/07/23 PM 03:45:54	4	00001B81	Start processing data
source '\dm_src\dm_model\zip.iqd'.
2001/07/23 PM 03:45:54	4	00001B81	Reading source data.


PowerPlay Transformer DA Server(6.5.283.0 )  Mon Jul 23 15:45:55 2001



PowerPlay Transformer DA Server  Mon Jul 23 15:45:57 2001
2001/07/23 PM 03:45:57	4	00001B81	End processing 368
records from data source '\dm_src\dm_model\zip.iqd'.
2001/07/23 PM 03:45:57	4	00001B81	Timing, READ DATA
SOURCE,00:00:03



2001/07/23 PM 03:45:57	4	00001B81	Marking categories
used.


2001/07/23 PM 03:45:57	4	00001B81	Timing, MARKING
CATEGORIES USED,00:00:00



2001/07/23 PM 03:45:57	4	00001B81	Initializing
categories.

2001/07/23 PM 03:45:57	4	00001B81	Timing, INITIALIZING
CATEGORIES,00:00:00
2001/07/23 PM 03:45:57	4	00001B81	Start processing data
source '\dm_src\dm_model\dl_type.iqd'.
2001/07/23 PM 03:45:57	4	00001B81	Reading source data.


PowerPlay Transformer DA Server(6.5.283.0 )  Mon Jul 23 15:45:58 2001



PowerPlay Transformer DA Server  Mon Jul 23 15:45:59 2001
2001/07/23 PM 03:46:00	4	00001B81	End processing 33
records from data source '\dm_src\dm_model\dl_type.iqd'.
2001/07/23 PM 03:46:00	4	00001B81	Timing, READ DATA
SOURCE,00:00:03



2001/07/23 PM 03:46:00	4	00001B81	Marking categories
used.


2001/07/23 PM 03:46:00	4	00001B81	Timing, MARKING
CATEGORIES USED,00:00:00



2001/07/23 PM 03:46:00	4	00001B81	Initializing
categories.

2001/07/23 PM 03:46:00	4	00001B81	Timing, INITIALIZING
CATEGORIES,00:00:00
2001/07/23 PM 03:46:00	4	00001B81	Start processing data
source '\dm_src\dm_model\mia_1998.iqd'.
2001/07/23 PM 03:46:00	4	00001B81	Reading source data.


PowerPlay Transformer DA Server(6.5.283.0 )  Mon Jul 23 15:46:01 2001



PowerPlay Transformer DA Server  Mon Jul 23 15:46:02 2001
2001/07/23 PM 03:46:02	4	00001B81	End processing 0
records from data source '\dm_src\dm_model\mia_1998.iqd'.
2001/07/23 PM 03:46:02	4	00001B81	Timing, READ DATA
SOURCE,00:00:02



2001/07/23 PM 03:46:03	4	00001B81	Marking categories
used.


2001/07/23 PM 03:46:03	4	00001B81	Timing, MARKING
CATEGORIES USED,00:00:00



2001/07/23 PM 03:46:03	4	00001B81	Initializing
categories.

2001/07/23 PM 03:46:03	4	00001B81	Timing, INITIALIZING
CATEGORIES,00:00:00
2001/07/23 PM 03:46:03	4	00001B81	Start processing data
source '\dm_src\dm_model\mia_1999.iqd'.
2001/07/23 PM 03:46:03	4	00001B81	Reading source data.


PowerPlay Transformer DA Server(6.5.283.0 )  Mon Jul 23 15:46:04 2001



PowerPlay Transformer DA Server  Mon Jul 23 15:46:06 2001
2001/07/23 PM 03:46:06	4	00001B81	End processing 0
records from data source '\dm_src\dm_model\mia_1999.iqd'.
2001/07/23 PM 03:46:06	4	00001B81	Timing, READ DATA
SOURCE,00:00:03



2001/07/23 PM 03:46:06	4	00001B81	Marking categories
used.


2001/07/23 PM 03:46:06	4	00001B81	Timing, MARKING
CATEGORIES USED,00:00:00



2001/07/23 PM 03:46:06	4	00001B81	Initializing
categories.

2001/07/23 PM 03:46:06	4	00001B81	Timing, INITIALIZING
CATEGORIES,00:00:00
2001/07/23 PM 03:46:06	4	00001B81	Start processing data
source '\dm_src\dm_model\mia_2000.iqd'.
2001/07/23 PM 03:46:06	4	00001B81	Reading source data.


PowerPlay Transformer DA Server(6.5.283.0 )  Mon Jul 23 15:46:07 2001



PowerPlay Transformer DA Server  Mon Jul 23 15:46:09 2001
2001/07/23 PM 03:46:09	4	00001B81	End processing 0
records from data source '\dm_src\dm_model\mia_2000.iqd'.
2001/07/23 PM 03:46:09	4	00001B81	Timing, READ DATA
SOURCE,00:00:03



2001/07/23 PM 03:46:09	4	00001B81	Marking categories
used.


2001/07/23 PM 03:46:09	4	00001B81	Timing, MARKING
CATEGORIES USED,00:00:00



2001/07/23 PM 03:46:09	4	00001B81	Initializing
categories.

2001/07/23 PM 03:46:09	4	00001B81	Timing, INITIALIZING
CATEGORIES,00:00:00
2001/07/23 PM 03:46:09	4	00001B81	Start processing data
source '\dm_src\dm_model\mia_2001.iqd'.
2001/07/23 PM 03:46:09	4	00001B81	Reading source data.


PowerPlay Transformer DA Server(6.5.283.0 )  Mon Jul 23 15:46:10 2001



2001/07/23 PM 03:46:12	2	00000000   DA	DMS-E-GENERAL, A

general exception has occurred during operation 'asynchronous open'.
2001/07/23 PM 03:46:12	2	00000000   DA	ORA-03232: unable to
allocate an extent of 8 blocks from 'tablespace 9'

2001/07/23 PM 03:46:12	2	00000000   DA	
2001/07/23 PM 03:46:12	2	00000000   DA	(TR0109) Transformer


couldn't read the data source.


PowerPlay Transformer DA Server  Mon Jul 23 15:46:12 2001
2001/07/23 PM 03:46:12	4	00001B81	End processing 0
records from data source '\dm_src\dm_model\mia_2001.iqd'.
2001/07/23 PM 03:46:12	4	00001B81	Timing, READ DATA
SOURCE,00:00:03


2001/07/23 PM 03:46:13	4	00001B81	End cube update.
2001/07/23 PM 03:46:13	4	00001B81	Timing, TOTAL TIME
(CREATE CUBE),00:00:28
2001/07/23 PM 03:46:13	2	00001B81	(TR3312) An error


occurred during data retrieval using the DA Server program. Refer to
the log for more details. [->OK]


PowerPlay Transformer  Mon Jul 23 15:46:13 2001



<Transformer log end>




The most suspicious error is this one:


ORA-03232: unable to allocate an extent of 8 blocks from 'tablespace
9'



A tablespace is normally identified by its name, but not a number, how
do you identify the 'talbespace 9' here? 



Thanks,


Dino
Received on Mon Jul 23 2001 - 02:53:53 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US