Solved

sqlquery format

Posted on 2014-03-31
4
231 Views
Last Modified: 2014-04-08
I want to know the sql query  for my  usertablespace creation..

Is there any way for that?
0
Comment
Question by:tonydba
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 16

Accepted Solution

by:
Wasim Akram Shaik earned 500 total points
ID: 39968442
Yes you can refer to this link for full details, just placing the syntax for your reference though

select dbms_metadata.get_ddl('TABLESPACE',tablespace_name) from dba_tablespaces;


http://www.dba-oracle.com/t_1_dbms_metadata.htm
0
 
LVL 23

Expert Comment

by:David
ID: 39978373
I recommend in your SQL session, prior to the SELECT command above:

SET LINESIZE 0                          NOTE  no semicolon nor /
0
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 39978538
-->>I recommend in your SQL session, prior to the SELECT command above:

This is needed only if your are using sql*plus , if you are using any other tool, such as toad or sql developer, this is not needed..
0
 

Author Closing Comment

by:tonydba
ID: 39986470
Thank you
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to recover a database from a user managed backup
Suggested Courses

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question