Jump to content
Sign in to follow this  
ryanw

create_views.create_ltt_view

Recommended Posts

Hi everyone

 

Iam running the below script and getting the error in the attached screen shot. Can anyone help? The table does exist.

 

begin
create_views.create_ltt_view('B$EVSTATION_N');
constraint_transfer.getprimaryconstraint('B$EVSTATION_N');
constraint_transfer.dropuniqueconstraint('B$EVSTATION_N');
constraint_transfer.dropuniqueindex('B$EVSTATION_N');
create_triggers.create_ltt_trigger('B$EVSTATION_N');
end;

post-204709-0-66570300-1485211110_thumb.png

Share this post


Link to post
Share on other sites

Maybe there's more information at the indicated line number. Why use $ in a table name, anyway?

 

Oracle strongly discourages you from using $ and # in nonquoted identifiers.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×