Can you do it? Sure, check out [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a76940/adl07md4.htm#117507[/url]

Should you do it? That depends on the application. Is all the data going to be needed all the time in cache? I would be inclined to have a large buffer cache instead of caching a whole table.