Re: Tablespace numbering

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 23 Jul 2001 13:04:22 +0100
Message-ID: <3b5c12e2$0$8508$ed9e5944@reading.news.pipex.net>

have a look at dba_tablespaces I believe the TS# is the number you are looking for.
"Dino Hsu" <dino1_nospam_at_ms1.hinet.net> wrote in message news:jnlnlto6kfuomlu5h83ffn7o86hlo9debv_at_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 - 07:04:22 CDT