I am new to teradata. I have teradata 14.0 express edition database and teradata utilities installed on my system. Everything looks fine except that when i open my DBC database i am not able to create any table under that. At the same time the "Samples" database found under teradata administrator is not found in teradata sql client. Can someone please assist me on this.
You have to add the Samples database in SQLA manually.
In the database explorer windows right click on the top most node, Select Add Database, and in the prompt enter database name, Click ok.
Refresh the database explorer window.
"when i open my DBC database i am not able to create any table under that" - that's right, the DBC database is a special system database. Even the user DBC does not have a CREATE TABLE privilege on DBC. :) You should create your tables in another databases, not in DBC.
With kind regards,
The best way is to create a user under dbc with max of perm, and then use this user to create other objects e.g databases, tables.