SQL

4 Types of SQL in Relational Database

Posted on
Types of SQL Statements SQL statements in relational database management system (RDBMS) could sometimes be too complicated to be analyzed for. As SQL developers, we should at least be able to distinguish what types of the statements that are using. According to conventional SQL classification, there are 4 basic types of SQL statements. Data Query […]
DDL

How to Resolve ORA-02494: invalid or missing maximum file size in MAXSIZE clause

Posted on
Generated DDL from tools may not be executable sometimes. I got ORA-02494 when I execute DDL scripts that were generated from other database by TOAD, a very popular administration tool used by DBA. Irrational DDL SQL> CREATE TABLESPACE PERSON DATAFILE   2    ‘/u02/app/oracle/oradata/datastore/.ACFS/snaps/orcl/ORCL/datafile/user01.dbf’ SIZE 5G AUTOEXTEND ON NEXT 20M MAXSIZE 4G   3  LOGGING […]