Search found 87 matches
- Wed May 29, 2013 5:00 am
- Forum: Vertica Database Administration
- Topic: User with dbadmin role cannot drop another user
- Replies: 2
- Views: 5945
User with dbadmin role cannot drop another user
Hi , Got a problem while dropping a user (created by DBADMIN ) connecting with the user who is having the DBADMIN Role Enabled.!! According to the Administrators guide , i'm having the following privileges to the user , who has DBADMIN Role Enabled. The DBADMIN Role Every database has the special DB...
- Sat May 18, 2013 7:56 am
- Forum: Vertica Database Development
- Topic: Is Snapshot in oracle and Vertica are same??
- Replies: 0
- Views: 3895
Is Snapshot in oracle and Vertica are same??
Hi..
As Oracle is having Snapshot option.. and even the vertica too..
Is Snapshot in oracle and Vertica are same??
Thanks
Raj!!
As Oracle is having Snapshot option.. and even the vertica too..
Is Snapshot in oracle and Vertica are same??
Thanks
Raj!!
- Sat May 18, 2013 5:43 am
- Forum: Vertica Database Development
- Topic: Do Vertica have Flashback table Concept??
- Replies: 1
- Views: 5224
Do Vertica have Flashback table Concept??
Hi,
As Oracle is having Flashback Concept,
Do Vertica too have Flashback Concept??
As Oracle is having Flashback Concept,
Do Vertica too have Flashback Concept??
- Fri May 17, 2013 2:29 pm
- Forum: Vertica Database Development
- Topic: Can we Lock Table??
- Replies: 3
- Views: 8806
Can we Lock Table??
HI,
Can a user lock a table in vertica?
As Oracle having the syntax as follows
Lock table <Table_Name> Exclusive Mode ;
Do Vertica have this kind of facility??
Thanks,
Raj!!
Can a user lock a table in vertica?
As Oracle having the syntax as follows
Lock table <Table_Name> Exclusive Mode ;
Do Vertica have this kind of facility??
Thanks,
Raj!!
- Fri Mar 29, 2013 5:25 am
- Forum: Vertica SQL
- Topic: Analyticts Functions Use Current Row Value
- Replies: 4
- Views: 14697
Re: Analyticts Functions Use Current Row Value
Hi knicely, Thanks a lot for your quick response. I have verified the timing also. By using the analytic function in the query, it is taking lot of time to retrieve the records compared to the normal aggregate function. Nearly it is taking 3 times the aggregate function execution time. Execution tim...
- Thu Mar 28, 2013 6:30 am
- Forum: Vertica SQL
- Topic: Analyticts Functions Use Current Row Value
- Replies: 4
- Views: 14697
Re: Analyticts Functions Use Current Row Value
Hi Knicely, Is using analytic function recommended one? Does it reduces the performance of the query? Eg: select Distinct Department , Count(Emp_ID) Over (Partition By Department) as Emp_Count From EMP; Can i use the above query instead of the below one!! Which performs better? Select Count(Emp_ID),...
- Fri Dec 28, 2012 7:54 am
- Forum: Vertica Database Development
- Topic: Error While Restoring the schema from a Database.
- Replies: 1
- Views: 5514
Error While Restoring the schema from a Database.
Hi, I Backed up a schema from one server of vertica version “Vertica Analytic Database v6.0.0-0” and trying to restore it in the another server of vertica version “Vertica Analytic Database v6.0.1-0”. When I was trying to restore the backup(after stopping the Database), it is showing an error like ‘...