where the actual file is stored??
-
Dear All, My question is: where the actual files stored in the database, i.e: if i have records of pdf files, are these files saved in the database tables of application it self (oracle, sql2008), or it will be some where on the H.D. and the path will be recorded in the database tables, lets say Oracle D.B?? Any clarification guys, Thanks in advance.
0 will always beats the 1.
-
Dear All, My question is: where the actual files stored in the database, i.e: if i have records of pdf files, are these files saved in the database tables of application it self (oracle, sql2008), or it will be some where on the H.D. and the path will be recorded in the database tables, lets say Oracle D.B?? Any clarification guys, Thanks in advance.
0 will always beats the 1.
Depends on the datatype. If it's a BLOB the file is stored directly in the database. If it's BFILE a reference to the filesystem is stored in the table. This answer is valid for Oracle. I would be surprised if SqlServer didn't have the same possibilities.
"When did ignorance become a point of view" - Dilbert
-
Depends on the datatype. If it's a BLOB the file is stored directly in the database. If it's BFILE a reference to the filesystem is stored in the table. This answer is valid for Oracle. I would be surprised if SqlServer didn't have the same possibilities.
"When did ignorance become a point of view" - Dilbert
Thanks Jörgen
0 will always beats the 1.
-
Thanks Jörgen
0 will always beats the 1.
You're welcome.
"When did ignorance become a point of view" - Dilbert