Fastload to VIEW
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
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.


Fastload to VIEW Expand / Collapse
Author
Message
Posted 6/26/2008 2:33:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 6/26/2008 5:18:03 AM
Posts: 1, Visits: 4
I am using fastload scripts to populate directly to a view(myview ).

But i am getting an error :

Begin Loading myview errorfiles mytable_e1,mytable_e2;
RDBMS error 3853: 'myview' is not a table.

How to resolve this? Is it possible to populate directly to view?
Post #11966
Posted 6/26/2008 2:37:16 AM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: Today @ 7:30:07 AM
Posts: 197, Visits: 611
Hello,

As you said, FastLoad loads in tables not the views, you need to load the underlying table(s) for updating view.

I suppose "RDBMS error 3853: 'myview' is not a table." is pretty self-explainatory.

Regards,

Adeel
Post #11967
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 2 ( 2 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 3:45pm

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.141. 9 queries. Compression Disabled.