Hi Guys I am new at oracle(SQLPlus ,as well) I am trying to run a sql file which contains more than 500 alter statement which is suppose to alter all of my tables.After running the @alterTab.sql in sqlplus the result display at cmd command but I can's navigate to previous pages to to see what table didn't alterd, so I tried to add a spool command at the top of my sql file like

SPOOL C:\_Result.txt
alter table TMN add( mpk varchar2(30), mfk varchar2(30) );
alter table TWE add( mpk varchar2(30), mfk varchar2(30) );

But this just create an empty txt file(_Result.txt) at C drive. Can you guys please let me know how I can spool all the cmd (SQLPlus) output on a file to see what is the result

6 Years
Discussion Span
Last Post by hfx642

First of all, NEVER start a filename with the "_" (underscore) character.
Some people can/do, but is really shouldn't be done.

Second, I always end ALL of my commands with the ";" (semicolon).
It's just proper syntax.

Third, I always end a sequence of commands with a "commit;", however redundant it may be. (Just like initializing a variable in the declaration, and then reinitializing the variable before using it. Just for "piece of mind".)

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.