
In order to generate, use oracle sql-developer to export the data into INSERT
statements.  
		
Massage: do not include the outermost "'s in the search expressions

For each table:
	search for "TABLE_NAME ", replace with "table_name " (not a regular expression)
	search for ","LAST_UPDATE"", replace with nothing (not a regular expression)
	search for ","LOCK_DATE"", replace with nothing (not a regular expression)
	search for ",to_date\('[^']*','DD-MON-RR'\)" replace with nothing (this is a regular expression)
	search for ""([^"]*)"" replace with the tagged expression
svc_domain
	search for "127.0.0.1" replace with the ip address of your conformance-ip (the ip of the box from which you will run regression)
	search for "172.16.0.22" replace with the ip address of your conformance-ip (the ip of the box from which you will run regression)
svc_mim_item
svc_mim_list
svc_definition
svc_template
subscr_profile
subscr_device

Then, remove all of the "REM" statements
Then, in the subscr_device file, remove the last entry (with all the null-values)

mysql -ucsn -pcsn csn < svc_domain.sql
mysql -ucsn -pcsn csn < svc_mim_item.sql
mysql -ucsn -pcsn csn < svc_mim_list.sql
mysql -ucsn -pcsn csn < svc_definition.sql
mysql -ucsn -pcsn csn < svc_template.sql
mysql -ucsn -pcsn csn < subscr_profile.sql
mysql -ucsn -pcsn csn < subscr_device.sql

Then, you have to change all the 0:00 timestamps to CURRENT_TIMESTAMP:
update subscr_profile set last_update=CURRENT_TIMESTAMP;

You have to change your Domains to point to the ip address of your regression-suite:
svc_domain:
	search for "127.0.0.1" replace with the ip address of your conformance-ip (the ip of the box from which you will run regression)
	search for "172.16.0.22" replace with the ip address of your conformance-ip (the ip of the box from which you will run regression)

