• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 690
  • Last Modified:

dba_tablespaces

SQL> @dba_tablespaces;
SP2-0310: unable to open file "dba_tablespaces.sql"
SQL>



The expected output is like this format..


--------- ------------------ ------------ ---------- --------- ----------------- ----------------- ---------
ONLINE    UNDOTBS1           UNDO         LOCAL      MANUAL        1,073,741,824         9,109,504         1
ONLINE    SYSAUX             PERMANENT    LOCAL      AUTO          1,073,741,824       545,062,912        51
ONLINE    USERS              PERMANENT    LOCAL      AUTO          1,073,741,824       133,365,760        12
ONLINE    SYSTEM             PERMANENT    LOCAL      MANUAL        1,073,741,824       525,991,936        49
ONLINE    EXAMPLE            PERMANENT    LOCAL      AUTO          1,073,741,824        63,045,632         6
ONLINE    UNDOTBS2           UNDO         LOCAL      MANUAL        1,073,741,824        11,927,552         1
ONLINE    TEMP               TEMPORARY    LOCAL      MANUAL        1,073,741,824        28,311,552         3
                                                               ----------------- ----------------- ---------
avg                                                                                                       18
sum                                                                7,516,192,768     1,316,814,848

7 rows selected.
0
walkerdba
Asked:
walkerdba
  • 2
  • 2
  • 2
  • +1
1 Solution
 
sdstuberCommented:
you need to include the path to your script  or start sqlplus from within the same directory where the script is located

assuming you execute it, does it produce the correct results?

if not, why not? what is the query in your script?
0
 
DavidSenior Oracle Database AdministratorCommented:
I recommend you fully specify the path for the SQL file.  It apparently is not in the directory from which you started your SQLPLUS session.
0
 
walkerdbaAuthor Commented:
seriously  I do not know the script for that out put....

I thought that inbuilt..

how to create script for that..
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
sdstuberCommented:
what are the numeric values supposed to be?

are those extents? bytes? data files?



how did you get that output if you don't know where to find the script?
0
 
DavidSenior Oracle Database AdministratorCommented:
A sys-privileged user may execute from a command prompt, SELECT * FROM sys.dba_tablespaces; to see output (without totals).  

If you exit out of your sqlplus session, what directory are you in?
0
 
Mark GeerlingsDatabase AdministratorCommented:
I'm not an expert in SQL Server, but this syntax "@dba_tablespaces;" looks to me like examples I have seen of SQL Server syntax.  Are you possibly familiar with SQL Server but new to Oracle?  If yes, be aware that these two database systems are very different!  Yes, they are both "SQL compliant" and they both store data in tables that contain rows and columns.  But, that is about the limit of their similarities.

There have been a number of postings in this forum over the years highlighting some of their major differences.
0
 
walkerdbaAuthor Commented:
found
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now