Request for a new rule: When creating index or table specific Tablespaces should be used. (4330771)

RESOLUTION

1. Go to View | Toad options | Code Analysis |General and, on the right panel select Edit Rules
2. Click on Create New Rule
3. 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