How to create a database in Teradata

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

How to create a database in Teradata

Rate Topic

Display Mode

Topic Options

Author

Message

Dileep Banala

Posted 8/19/2008 7:30:46 AM

Junior Member

Group: Forum Members
Last Login: 8/22/2008 11:30:56 AM
Posts: 22, Visits: 41

Hi

I Have just installed DemoCD of Teradata V2R5.
How to create a sample database for DemoCD.
and how to create tables under it?

which utility should i use?

Thanks

Dileep

Post #12647

hvganipineni

Posted 8/19/2008 1:57:39 PM

Forum Newbie

Group: Forum Members
Last Login: 9/5/2008 9:13:05 AM
Posts: 6, Visits: 31

CREATE DATABASE datbasename
FROM parent
AS
PERM = 100K
SPOOL = 500K
FALLBACK
ACCOUNT= 'ACCTG'
NO AFTER JOURNAL
DUAL BEFORE JOURNAL
DEFAULT JOURNAL TABLE = databasename.journals;

Post #12652

hvganipineni

Posted 8/19/2008 1:58:03 PM

Forum Newbie

Group: Forum Members
Last Login: 9/5/2008 9:13:05 AM
Posts: 6, Visits: 31

sorry you can use sql assistant to do the same.

-Harsha

Post #12653

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 1 ( 1 guest, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 12:11am