Hi,
We are using IFS managed cloud services and store our documents in the oracle database.
We have around 2500 GB of document data in our database (tablespace IFSAPP_LOB), and we are planning to analyze the document using these categories before the cloud migration.
We must come up with a strategy to offload some of the data prior to the migration as it will take lot of time for the migration.
Do any of you have any SQL quries that I might use to query the database tables?
We'd like to know:
How many GBs are available for each document file format (for example, JPEGs and PDFs)? (file type is available in EDM_FILE view)
How much GBs each company is using as documents (for example, 600 GB for company 1 for doc class 001) so do you know how to connect company to documents?
When I first started analyzing, I noticed that the document count (doc_no) for EDM_FILE_STORAGE views differs from that of doc_issue_tab and EDM_FILE. This indicates that certain documents do not include a blob or actual data(When I check such a file in the Document Revision window, the view and edit buttons are grayed out)
Example: Blob is only stored at EDM_FILE_STORAGE
Thanks in advance.
Axkey