I am using pkg_import to import a CAR file. Before actually importing, I would like to find out whether my CAR file contains cache tables.

You can use the -printcontents option to view the contents of the CAR file. This option disables the actual import, and prints properties of the CAR file to the command window.

Example
C:\apps\tdv760\bin\pkg_import.bat -pkgfile C:\cust\Putnam\01586793_cache_Same\SecondTestViewForCust.car   -user admin -password admin -printcontents -server localhost -port 9450

Importing file "C:\cust\Putnam\01586793_cache_Same\SecondTestViewForCust.car".
Contents:
  /shared/test_folder/SecondTestViewForCust
  /shared/test_folder/oracle_11_data_source
  /shared/test_folder/oracle_11_data_source/JOE
  /shared/test_folder/oracle_11_data_source/JOE/EMPLOYEE
  /shared/test_folder/oracle_11_data_source/JOE/EMP_ACTIVE_POS
  /shared/test_folder/oracle_11_data_source/JOE/MY_SLEEP
  /shared/test_folder/oracle_11_data_source/JOE/WAIT_A_WHILE
  /shared/test_folder/oracle_11_data_source/JOE/cache_SecondViewForCust
  /shared/test_folder/oracle_11_data_source/JOE/cache_TestViewForCust
  /shared/test_folder/oracle_11_data_source/JOE/cache_some_numbers
  /shared/test_folder/oracle_11_data_source/JOE/cache_status
  /shared/test_folder/oracle_11_data_source/JOE/cache_tracking
Done importing file "C:\cust\Putnam\01586793_cache_Same\SecondTestViewForCust.car".

This output shows that the CAR file contains the following:

•  a cache tracking table (cache_tracking)
•  a cache status table (cache_status)
•  cache target tables (cache_some_numbers, cache_TestViewForCust,   cache_SecondViewForCust)

Alternatively, you can use the Import Preview button in Studio as shown below. Make sure to click the Cancel button when you are done.

       

I am using pkg_import to import a CAR file. Before actually importing, I would like to find out whether my CAR file contains cache tables.