I want to use a large rollback segment for an import. Is there a way to make the import to use a specific RBS?
David Knight OCP DBA 8i, 9i, 10g
You can't specify a rollback segment for Import but you can create a big rbs and take the all other small segments OFFLINE (except system), import will use that big rbs. Sanjay
Or, set your buffer size smaller than your RBS and use COMMIT=y with import.
Jeff Hunter
Forum Rules