Run script from where it stopped

Scripts Diversos para o Oracle SQL*Plus. (Relacionado a ferramenta Oracle SQL*Plus, para questões de SQL, usar o forum SQL)
Post Reply
Lm_mJ
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 2
Joined: Thu, 17 Sep 2009 1:20 pm
Location: Santos
Jose Monteiro de Farias Junior

Hello friends,

I am new to the forum I have a doubt I will be eternally grateful if you can help me,

After creating Banco Oracle I started to create the data and rode the oracle scripts

Select all

\rdbms\admin\catalog.sql 
and

Select all

\rdbms\admin\catproc.sql
only in the middle of the catproc.sql my micon turned off as I do to Rotate the script from where did you stop?

Better to do all again?

I tried to rotate it again but from an error and disconnect from the bank

= /
Jota
Rank: Analista Júnior
Rank: Analista Júnior
Posts: 77
Joined: Wed, 17 Jun 2009 3:18 pm
Location: Blumenau - SC
Jonatas Jaqmam Pereira
Analista Desenvolvedor de Sistemas

When you tried to run again which mistake did you give?
Lm_mJ
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 2
Joined: Thu, 17 Sep 2009 1:20 pm
Location: Santos
Jose Monteiro de Farias Junior

Select all

raise_application_error <-20000 
 
ERROR at line 6 
ORA-06550: line 6, column 9: 
PLS-00201: IDENTIFIER 'raise_application_error' must be declared 
ORA-06550: line 6, column 9: 
PL/SQL: Statement ignored 
 
Disconnected from oracle database 10g...
Jota
Rank: Analista Júnior
Rank: Analista Júnior
Posts: 77
Joined: Wed, 17 Jun 2009 3:18 pm
Location: Blumenau - SC
Jonatas Jaqmam Pereira
Analista Desenvolvedor de Sistemas

Dude, I do not know what it's about, there's a lot in this script ...

I advise you to start the process again, more guaranteed that everything will be right.
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 11 guests