Re: Using dbms_ldap
Date: Sat, 16 Aug 2008 00:37:42 -0700 (PDT)
Message-ID: <93d403fb-f8d7-4c18-95c8-d902b2e68ee9@b2g2000prf.googlegroups.com>
hi jg,
thank you for your input. As recommended by you, i used dnms_ldap, but quickly i bumped into a problem, I am getting sizeexceeded limit. so i decided to use /usr/bin/ldapsearch to dump few fields to a text file. but now i'm clueless on how to import data from a text file to a table.
output(sample) looks like this
# Alex Fontana, Users, nbc.com
dn: CN=Ali Fon,CN=Users,DC=nbc,DC=com
givenName: Ali
department: Infrastructure - 19622
employeeNumber: 034636
employeeID: 034636
mail: afon_at_nbcc.com
manager: CN=Bob Plu,CN=Users,DC=nbc,DC=com
# Aravind Pavu, Users, nbc.com
dn: CN=Aravind Pavu,CN=Users,DC=nbc,DC=com
givenName: Aravind
department: R&D: Performance - 72200
employeeNumber: 035870
employeeID: 035870
mail: apavu_at_nbcc.com
manager: CN=Raji Kam,CN=Users,DC=nbc,DC=com
Now how do I insert each block as one row into a table. Please give me some hints.
thank you
.ra
Received on Sat Aug 16 2008 - 02:37:42 CDT