FTK2 database
Accessing the FTK2 database
I wanted to access the FTK2 oracle database to have a look at the tables in use. I've never used Oracle before and it took me an a an hour + Google to work out how to access the tables - but this worked for me.
I gained access to the database by:
- creating a password file in d:\Oracle\ftk2\dbs\ using orapwd file=${ORACLE_HOME}/dbs/orapwftk2 password=ftk2 entries=100.
- Then ran: orapwd force=y file=orapwftk2 password=ftk2
- I dont think the last step was needed.
- Rebooted
- Then logged in using: sqlplus /nolog
- connect / as sysdba
- select name,password from sys.user$;
- SQL> create user dan identified by dan;
- grant connect to dan
- grant sysdba to dan
- GRANT RESOURCE, CONNECT, CREATE VIEW, CREATE ANY DIRECTORY, DROP ANY DIRECTORY, CREATE JOB, CREATE SYNONYM, MANAGE TABLESPACE, SELECT ANY TABLE, CTXAPP, EXP_FULL_DATABASE, IMP_FULL_DATABASE, CREATE USER, ALTER USER to dan;
- GRANT EXECUTE ON SYS.DBMS_LOCK TO dan;
- GRANT EXECUTE ON SYS.DBMS_AQADM TO dan;
- GRANT EXECUTE ON CTXSYS.CTX_DDL TO dan;
- GRANT aq_administrator_role TO dan;
- GRANT EXECUTE ON DBMS_FILE_TRANSFER TO dan;
I've installed an opensource tool called SQLTools_pp which is pretty nice for viewing the tables and the data within. I was suprised to find that FTK2 appears to dump most of the information relating to all files within a case & for all exhibits into a table called Objects. I'm no SQL expert, but i'm sure things would run a bit quicker if they made use of more tables or at least used a seperate table for each exhibit!