Unable to find Samples database from Teradata SQL Client

Database
Enthusiast

Unable to find Samples database from Teradata SQL Client

Dear All,

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.

Regards

Suresh

3 REPLIES
Enthusiast

Re: Unable to find Samples database from Teradata SQL Client

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.

Khurram
Teradata Employee

Re: Unable to find Samples database from Teradata SQL Client

"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,

Vlad.

Enthusiast

Re: Unable to find Samples database from Teradata SQL Client

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.

Khurram