How To Create Tables for ODBC Connection Testing

Q

How To Create Tables for ODBC Connection Testing? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection

✍: FYIcenter.com

A

If you want to follow the tutorial exercises in the sections below, you need to create a user account and a table for ODBC connection testing as shown here:

SQL> CONNECT system/retneciyf
Connected.

SQL> CREATE USER fyi IDENTIFIED BY retneciyf ACCOUNT UNLOCK;
User created.

SQL> GRANT CREATE SESSION TO fyi;
Grant succeeded.

SQL> GRANT CREATE TABLE TO fyi;
Grant succeeded.

SQL> ALTER USER fyi DEFAULT TABLESPACE USERS;
User altered.

SQL> ALTER USER dev QUOTA 4M ON USERS;
User altered.

SQL> connect fyi/retneciyf;
Connected.

SQL> CREATE TABLE dev_faq (id NUMBER);
SQL> INSERT INTO dev_faq VALUES (3);
SQL> INSERT INTO dev_faq VALUES (5);
SQL> INSERT INTO dev_faq VALUES (7);

2007-04-17, 4611👍, 0💬