# add datafile to tablespace = DB module?

**URL:** <https://forums.toadworld.com/t/add-datafile-to-tablespace-db-module/10576>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [July 19, 2011, 8:10am UTC](https://forums.toadworld.com/t/add-datafile-to-tablespace-db-module/10576 "2011-07-19T08:10:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [July 19, 2011, 8:10am UTC](https://forums.toadworld.com/t/add-datafile-to-tablespace-db-module/10576/1 "2011-07-19T08:10:13Z")

</div>

add datafile to tablespace = DB module?

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [July 19, 2011, 8:10am UTC](https://forums.toadworld.com/t/add-datafile-to-tablespace-db-module/10576/2 "2011-07-19T08:10:14Z")

</div>

That panel remain blank until you row select a tablespace on the LHS for the RHS  
to show the details for – so did you choose a tablespace on LHS?

---

<div class="post-metadata">

**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:** [July 19, 2011, 8:35am UTC](https://forums.toadworld.com/t/add-datafile-to-tablespace-db-module/10576/3 "2011-07-19T08:35:43Z")

</div>

Without the DBA Module, you can’t see tablespaces in the schema browser,  
and there is no ‘add datafile’ button.

This is what I was referring to, but you won’t be able to see it without  
the DBA module (until Toad 11, when tablespaces and lots of other DBA Module  
stuff get moved to ‘base’ Toad in the schema browser)

In my email below of July 15th at 9:56 AM, I was referring to the tablespaces  
screen. Since you don’t have the DBA module this is your only way to add a  
datafile in Toad (besides writing the sql statement yourself in the editor)

 ![image002.png](https://global.discourse-cdn.com/quest/original/2X/4/44227f494b2add2957f7d71fbd03bf7de055f26a.png)

---

<div class="post-metadata">

**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:** [July 19, 2011, 8:35am UTC](https://forums.toadworld.com/t/add-datafile-to-tablespace-db-module/10576/4 "2011-07-19T08:35:43Z")

</div>

Without the DBA Module, you can’t see tablespaces in the schema browser,  
and there is no ‘add datafile’ button.

This is what I was referring to, but you won’t be able to see it without  
the DBA module (until Toad 11, when tablespaces and lots of other DBA Module  
stuff get moved to ‘base’ Toad in the schema browser)

In my email below of July 15th at 9:56 AM, I was referring to the tablespaces  
screen. Since you don’t have the DBA module this is your only way to add a  
datafile in Toad (besides writing the sql statement yourself in the editor)  
 ![image001.png](https://global.discourse-cdn.com/quest/original/2X/0/0e8d79dd33d23856757ef17bcc88b700d4e0671f.png)