I'm having a table which contains 10 Lakh lines and need to export into different file which contails 1 Lakh lines each .
sample_01.sql ,sample_02.sql and so on
How can we take export like this in oracle.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
1 Lakh = 100,000.
10 Lakh = 1 million.
Question: Why do you want to do this?
A million row database table is not that significant these days.
A million row file won't give any modern file system much difficulty either.
OK, you won't find many editor programs that will allow you to usefully open such a file but - again - why would you want to?
Files, in this context, should be seen as a Transport media, not something that you'd want to actively work with except, perhaps, to load them into another database!