SQL*Plus: Release 11.2.0.3.0 Production on Wed Nov 19 15:19:11 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
NAME
--------------------------------------------------------------------------------
+DATA/orcl/datafile/system.256.858781235
SQL> select block_size * &block_id from dba_tablespaces where tablespace_name='&tablespace_name';
Enter value for block_id: 89248
Enter value for tablespace_name: SYSTEM
old 1: select block_size * &block_id from dba_tablespaces where tablespace_name='&tablespace_name'
new 1: select block_size * 89248 from dba_tablespaces where tablespace_name='SYSTEM'