Search found 49 matches

by Brett
Thu Mar 06, 2014 4:51 pm
Forum: New to Vertica Database Administration
Topic: Auto Commit at the DB level?
Replies: 1
Views: 5261

Auto Commit at the DB level?

Hi!

Is there an autocommit feature at the DB level? Or is this a feature only available with vsql?

Thank you
by Brett
Wed Feb 26, 2014 2:07 pm
Forum: New to Vertica Database Administration
Topic: DIsplaying Data Types and Sizes of System Tables
Replies: 1
Views: 5208

DIsplaying Data Types and Sizes of System Tables

Howdy,

Is there a way that I can see the data types and sizes of the columns in a system table? If I try to export one I get an error:

Code: Select all

dbadmin=> select export_objects('', 'sessions');
ERROR 2425:  Cannot export virtual table sessions
by Brett
Wed Feb 19, 2014 1:41 pm
Forum: New to Vertica Database Administration
Topic: Get status of a long running insert ...
Replies: 12
Views: 24600

Re: Get status of a long running insert ...

Thanks for the great feedback! I am using Vertica 7 by the way... I will try some of the suggestions provided and will post my findings :)
by Brett
Tue Feb 11, 2014 6:12 pm
Forum: New to Vertica Database Administration
Topic: Get status of a long running insert ...
Replies: 12
Views: 24600

Get status of a long running insert ...

Hi,

Is there a way to find out how many records of a long running insert statements have been inserted? I can't tell if the process is hanging or if its just slow.
by Brett
Tue Feb 04, 2014 8:31 pm
Forum: Vertica Database Administration
Topic: Are Views being Used?
Replies: 1
Views: 4506

Are Views being Used?

Howdy,

Is there some way I can tell if a view is being used? I'd to clean up some views (i.e. drop them) but I don't want to drop any that are be used.

Thanks...
by Brett
Tue Jan 28, 2014 12:30 pm
Forum: New to Vertica Database Administration
Topic: How do I copy sequences to a new DB?
Replies: 1
Views: 5797

How do I copy sequences to a new DB?

Hi,

How can I copy sequences from one db to another so that they maintain the current values from the original db. If I go the export_objects route, it does not retain the current value of the sequence.

Thank you.
by Brett
Mon Jan 13, 2014 3:00 pm
Forum: New to Vertica
Topic: Why run compute_flextable_keys_and_build_view()?
Replies: 0
Views: 4046

Why run compute_flextable_keys_and_build_view()?

What does this message mean when I try to select from a flex table I created? dbadmin=> select * from flex_test_view; status ------------------------------------------------------------------------------------------------------------------------------ Please run compute_flextable_keys_and_build_view...

Go to advanced search