How to save all typed commands in SQLPLUS environment!!!

[rajeshbalusu]

Hi friends,

I am rajesh, am new to Oracle DBA.i have one doubt.
i.e. How can we save the sqlplus environment while from starting to end of the session..

for better to understand please see the attachment..

in this whatever the commands i have entered i want to save those commands into one text file from starting to end of the session...


Please help me ...


Thanks
Rajesh

[ales]

Hi,
look at the spool command. It saves all typed commands and feedbacks.

[rajeshbalusu]

Hi,

can you give me small discription about the same?
for example i have started sqlplus environment now....and i have entered some of the commands ....and so on....and am exited.
Now i want to save these all typed commands in to one textfile based on date like "08032009.txt".
as you told how to initialize this .txt file before entering any commands in sqlplus environment.


Thanks
Rajesh

[ales]

So, do you think I'm a documentation interface?

SQL> spool 08032009.txt
SQL> -- your commands here
SQL> spool off

[rajeshbalusu]

Hi,

After saving how can i open that saved file again?

i am unable to fine the location of that file physically.

Thanks
Rajesh

[PAVB]

Hi,

After saving how can i open that saved file again?

i am unable to fine the location of that file physically.

Thanks
Rajesh

No offense but I would start with simple O/S stuff, then move into Oracle.