SQL+ running time error
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"
Software/Hardware used:
Software/Hardware used:
ASKED:
February 6, 2009 6:27 PM
UPDATED:
February 9, 2009 3:19 PM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
