# Tablespace DDL **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [June 6, 2017, 2:58pm UTC](https://forums.toadworld.com/t/tablespace-ddl/39562 "2017-06-06T14:58:36Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![mvk2585](https://avatars.discourse-cdn.com/v4/letter/m/b19c9b/32.png) [@mvk2585](https://forums.toadworld.com/u/mvk2585)\ **Post date:** [June 6, 2017, 2:58pm UTC](https://forums.toadworld.com/t/tablespace-ddl/39562/1 "2017-06-06T14:58:36Z")
Hi Team I am very fond of TOAD and want to see how toad is generating Tablespace DDL i tried to use SQL Tracker to see the script of Tablespace but i couldnt get the script that TOAD is using to generate the DDL I tried DBMS\_METADATA but its not giving me the correct way, where as TOAD is providing the correct way. Can some one help me to get the Correct SCRIPT to pull the Tablespace DDL how toad is pulling the same way Appreciate it. ---
**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\ **Post date:** [June 7, 2017, 3:08am UTC](https://forums.toadworld.com/t/tablespace-ddl/39562/2 "2017-06-07T03:08:04Z")
Use Toad debug in a way that you choose menu item: Database|Spool SQL|“Spool sql to screen” This start “recording” everthing toad is doing in screen (lower tab window. Choose command you like. Then you could see what Toad is doing. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [June 7, 2017, 5:25am UTC](https://forums.toadworld.com/t/tablespace-ddl/39562/3 "2017-06-07T05:25:45Z")
We don’t have a query that has the tablespace DDL as a result. We build that out of the query results. If you use Spool SQL or SQL Tracker, you’ll see the queries that we run. Everything you need is in the result of those queries.