# Create script from Tablespaces

**URL:** <https://forums.toadworld.com/t/create-script-from-tablespaces/37944>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [June 30, 2016, 1:27am UTC](https://forums.toadworld.com/t/create-script-from-tablespaces/37944 "2016-06-30T01:27:53Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![zoripi](https://avatars.discourse-cdn.com/v4/letter/z/9fc348/32.png) [@zoripi](https://forums.toadworld.com/u/zoripi)\
**Post date:** [June 30, 2016, 1:27am UTC](https://forums.toadworld.com/t/create-script-from-tablespaces/37944/1 "2016-06-30T01:27:53Z")

</div>

Hi, friends!

I currently work with the version of Toad 11.0.0.116. When I try to generate a script creating tablespaces, not me information about diskgroup or filesystem where datafiles are stored appears .

I have reviewed the script options available but none allows me to view that information.

The current script is, for example:

CREATE BIGFILE TABLESPACE xxxxxxxx DATAFILE  
SIZE xxxM AUTOEXTEND ON NEXT 1M MAXSIZE xxxM  
LOGGING  
ONLINE  
EXTENT MANAGEMENT LOCAL AUTOALLOCATE  
BLOCKSIZE 8K  
SEGMENT SPACE MANAGEMENT AUTO  
FLASHBACK ON;

And I need to see something like this:

CREATE BIGFILE TABLESPACE xxxxxxxxDATAFILE  
‘+DG\_DATA’ SIZE xxxxM AUTOEXTEND ON NEXT 10M MAXSIZE xxxxM  
LOGGING  
ONLINE  
EXTENT MANAGEMENT LOCAL AUTOALLOCATE  
BLOCKSIZE 8K  
SEGMENT SPACE MANAGEMENT AUTO  
FLASHBACK ON;

In case that it is not a bigfile tablespaces the problem is the same.

In previous versions of Toad I never had this problem. I’ve always been able to see all the information .

How can I solve that?

Thanks for all 🙂

```auto

```

---

<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:** [June 30, 2016, 8:01am UTC](https://forums.toadworld.com/t/create-script-from-tablespaces/37944/2 "2016-06-30T08:01:36Z")

</div>

That was a bug in 11.0. Sorry about that. ☹

It was fixed in the next version, 11.5, and it still works in the current version, 12.9.

---

<div class="post-metadata">

**Author:** ![zoripi](https://avatars.discourse-cdn.com/v4/letter/z/9fc348/32.png) [@zoripi](https://forums.toadworld.com/u/zoripi)\
**Post date:** [June 30, 2016, 11:54pm UTC](https://forums.toadworld.com/t/create-script-from-tablespaces/37944/3 "2016-06-30T23:54:31Z")

</div>

Ok, I will look the new version. Thanks for your help, John!
