RESOLUTION
- Go to View | Toad options | Code Analysis |General and, on the right panel select Edit Rules
- Click on Create New Rule
- Enter the Description, the tip and the XPath Expression provided below
//CREATE/(TABLE, INDEX)
[ not( TABLESPACE/QNAME/@value=("test", "users") ) ]
/QNAME
See if this rule works:
If we create the table below:
CREATE TABLE za_testRules
(
col1 NUMBER,
col2 NUMBER
)
we get rule 7002:
If we add the tablespace, rule 7002 should disappear
STATUS
This rule has been added in Toad for Oracle 13.0 as Rule 2143 ("When creating an index or a table then specific tablespaces should be used.") .The latest version of Toad for Oracle can be downloaded
here
