November 25, 2008
After you create an oracle job, you may need to edit it.
Oracle provides a procedures for the same.
Eg: to change the next time a job is to be run,
dbms_job.next_date(
job IN BINARY_INTEGER,
next_date IN DATE);
Log in as the user who owns the job and execute a commit after the operation.
ref: http://www.psoug.org/reference/dbms_job.html
November 15, 2008
In the absence of any UI based Oracle Database access tools, one has to access the same using SQL PLUS.
The following tables are helpful in getting information about tablespaces
Referred from http://www.cs.uvm.edu/oracle9doc/server.901/a90117/tspaces.htm#570
I have used the following tables:
V$TABLESPACE : Name and number of all tablespaces from the control file.
V$DATAFILE : Information about all datafiles, including tablespace number of owning tablespace.
DBA_DATA_FILES : Shows files (datafiles) belonging to tablespaces.
