In response to my last blog, I received the question: ‘Is Power View supposed to be a replacement for Oracle OBIEE 11g?’ This blog is aimed at answering that question. Before we start, however, I would like to say that these opinions expressed here are mine, and no-one else’s opinions. Therefore, if I’ve got some … Continue reading Is Power View supposed to be a replacement for Oracle BI Answers in OBIEE 11g
Connecting SSIS and Oracle: Issue and Resolution #1
Connecting from SQL Server SSIS to Oracle can be problematic, to say the least! I'm logging them on my blog as I find them. One error message that turned up recently was the following: cannot resolve connection This can mean that there is a line missing from the Oracle file called SQLNET.ORA. For some older implementations of Oracle, … Continue reading Connecting SSIS and Oracle: Issue and Resolution #1
SSIS and Oracle: challenge of ‘Unable to extend temp segment’ in Oracle
If SSIS is being used to retrieve large amounts of data from an Oracle database, the SSIS package may fail with the following error message:ORA-01652: unable to extend temp segment by 256 in tablespaceThis error basically means that Oracle could not extend the temporary segment for the required number of blocks in the user's allocated tablespace. There … Continue reading SSIS and Oracle: challenge of ‘Unable to extend temp segment’ in Oracle
Creating Oracle Tables using SSIS
It's possible to use SSIS to create a new Oracle table for you. However, there are a few 'gotchas' that it's necessary to look out for.It's possible to use the 'OLE DB Destination' adapter to insert data into Oracle. Thus, if a new Oracle table is required, it's possible to select the destination Oracle database, and use the 'New' … Continue reading Creating Oracle Tables using SSIS