SQL+ running time error

5 pts.
Tags:
SQL
SQL error messages
SQL Plus
Windows XP
Can anyone let me know I have a problem to run SQL that after runing sql_build_tables.sql why c:sql_build_tables.txt is empty (0 byt)- this use Win XP to run However, when I use Vista to run the SQL show Cannot create SPOOL file "c:sql_build_tables.txt" as show below OBJECT_TYPE COUNT(*) -------------------------------------- --------- SEQUENCE 5 TRIGGER 2 TABLE 1253 INDEX 81 VIEW 11 5 rows selected. SQL> SQL> SQL> select decode(constraint_type, 2 'p','primary key constraint', 3 'c','check constraint', 4 'r','referential integrity constraint', 5 'u','uniqueness constraint', 6 constraint_type) as constraint_type, 7 count(*) 8 from user_constraints 9 group by constraint_type; CONSTRAINT_TYPE COUNT(*) ---------------------------------------------------------------- --------- PRIMARY KEY CONSTRAINT 79 CHECK CONSTRAINT 86 2 rows selected. SQL> SQL> SQL> spool off; not spooling currently SQL> SQL> set define off; SQL> set echo off; . ************************************************************* . * * . * The tables have finished loading. * . * * . ************************************************************* SQL> spool c:sql_build_tables.txt; SP2-0606: Cannot create SPOOL file "c:sql_build_tables.txt"

Answer Wiki

Thanks. We'll let you know when a new response is added.

This could be a permissions problem in vista. Make sure you have write access to the location where you want to create the spool file.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following