Copying longs in Perl
From: Jason Heinrich <jheinrichdba_at_gmail.com>
Date: Mon, 5 Oct 2009 14:18:28 -0500
Message-ID: <b32e774d0910051218i5679b316w35132ea8ed9afd90_at_mail.gmail.com>
I have a perl script that manages audit data, and one of the things it does is create a copy of the sys.aud$ table in a separate tablespace for archiving purposes. I'm attempting to add the sys.fga_log$ table to this script so I can manage the fine-grained audit data as well, but it contains a long column so I can't just do a "create table as select" or I'll get an ORA-00997. The standard answer to this problem is to use the copy command in sqlplus, but I'd prefer to keep the code in perl. Is this possible?
Date: Mon, 5 Oct 2009 14:18:28 -0500
Message-ID: <b32e774d0910051218i5679b316w35132ea8ed9afd90_at_mail.gmail.com>
I have a perl script that manages audit data, and one of the things it does is create a copy of the sys.aud$ table in a separate tablespace for archiving purposes. I'm attempting to add the sys.fga_log$ table to this script so I can manage the fine-grained audit data as well, but it contains a long column so I can't just do a "create table as select" or I'll get an ORA-00997. The standard answer to this problem is to use the copy command in sqlplus, but I'd prefer to keep the code in perl. Is this possible?
--
Jason Heinrich
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 05 2009 - 14:18:28 CDT