Search found 33 matches

by khine
Thu Apr 04, 2013 5:38 pm
Forum: Vertica Database Administration
Topic: CREATE SCHEMA is not working
Replies: 12
Views: 21926

Re: CREATE SCHEMA is not working

I dont know how to go to cd in vertica but only in terminal .I try to go cd with this command "cd / opt/vertica/examples/VMart_Schema/ " but not successful.
by khine
Thu Apr 04, 2013 8:18 am
Forum: Vertica Database Administration
Topic: CREATE SCHEMA is not working
Replies: 12
Views: 21926

Re: CREATE SCHEMA is not working

I can successfully created database schema but i have error with to load data nito schema One of the error is "sql:/opt/vertica/examples/VMart_Schema/vmart_load_data.sql:4: ERROR 2886: Could not open file [/home/kay/Date_Dimension.tbl] for reading; No such file or directory HINT: Make sure the file ...
by khine
Thu Apr 04, 2013 2:31 am
Forum: Vertica Database Administration
Topic: CREATE SCHEMA is not working
Replies: 12
Views: 21926

Re: CREATE SCHEMA is not working

Thanks Jim now problem has been solved :)
by khine
Wed Apr 03, 2013 9:01 am
Forum: Vertica Database Administration
Topic: CREATE SCHEMA is not working
Replies: 12
Views: 21926

Re: CREATE SCHEMA is not working

Hi I am having this error during my creating database schema "/opt/vertica/vmart_define_schema.sql: No such file or directory" Anybody knows how to fix this error ?

Thanks regrads
by khine
Wed Apr 03, 2013 8:57 am
Forum: New to Vertica Database Administration
Topic: Change owner of schema?
Replies: 8
Views: 47266

Re: Change owner of schema?

Hi there can i ask you a ques that how can i create a database schema ?

Go to advanced search