Search found 221 matches

by Julie
Mon Apr 23, 2012 6:53 pm
Forum: New to Vertica Database Administration
Topic: Change table column's data type
Replies: 10
Views: 28518

Change table column's data type

Hello,

How do we change the data type of a table column? For instance, I would like to increase the size of several columns from VARCHAR(25) to VARCHAR(100).
by Julie
Sun Apr 22, 2012 12:37 am
Forum: New to Vertica Database Administration
Topic: Change Database Owner
Replies: 4
Views: 11758

Re: Change Database Owner

Hi,

Me again, how did you get your prompt to look like this:
  • [dbadmin :: ~ ]~>
Julie
by Julie
Sun Apr 22, 2012 12:21 am
Forum: New to Vertica Database Administration
Topic: Change Database Owner
Replies: 4
Views: 11758

Re: Change Database Owner

OMG! Thank you! This is perfect! I tried this in our test system and it worked perfectly! Now to get signoff for PROD! Thank you so much! I'm a new DBA at my company and was thrown into this Vertica thing - which I certainly don't mind. Anyway, thanks for your help sKwa!
by Julie
Thu Apr 19, 2012 9:33 pm
Forum: New to Vertica Database Administration
Topic: Change Database Owner
Replies: 4
Views: 11758

Change Database Owner

Hello,

We created our Vertica database using the default settings. So now the database is owned by the Linux user dbadmin. Is it possible to change the database owner without reinstalling Vertica from scratch?

If anyone can help, I'd really appreciate it!

Go to advanced search