New answers tagged etl
In addition to what the others have said, you could keep some data in flat files and them copy the files to the ephemeral storage on startup. You could then access it using external tables. I don't know if this would be faster or better, but it is another possible use.
As Ste says in his answer, temp tablespaces should be fine for this, so global temporary tables and other transient storage would be good. If you wanted to use permanent tablespaces then you could DROP TABLESPACE my_tablespace INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS before system shutdown if the storage was going to be lost, and recreate on ...
Oracle does not record checkpoint information in tempfile. So, for the tempfile: Oracle is able to start even if tempfile is missing. You will get a message in the alter log and you should recreate tempfile. No backup is taken of tempfile so it's safe to loose it There is no need to trick with any storage parameter for tempfile if resides on ephemeral ...
The only 'tool' that can read an MDF and LDF is an appropriately versioned edition of SQL Server. You need to install a SQL Server instance, attach the database to it and then use your preferred ETL tool to connect to this SQL Server and read data from the database.
If you are confident in the integrity of the data being imported, it may be a good idea to disable all the constraints to your database before beginning your inserts and then re-enabling them after the fact. See this helpful stack overflow answer from awhile back: Can foreign key constraints be temporarily disabled using T-SQL? This will save you the head ...
The simplest way to handle this may be a bit field like IsDirty that is updated with a trigger, and set to 0 for the whole table when you run your ETL. If this is set to 1 for every row that is updated, and you give it a default value of 1, then you can make export views for your ETL that filter on IsDirty = 1 so you only interact with new rows. If you ...
Top 50 recent answers are included