Toad World® Forums

Create script from Tablespaces

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 :slight_smile:


That was a bug in 11.0. Sorry about that. :frowning:

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

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